Interface diagram:
GeneratedCodeAs follows: (run through sqlhelp encapsulation)
Using system;
Using system. Data. sqlclient;
Using system. Data;
Namespace etime. BEP
{
/// <Summary>
/// Projecttask
/// </Summary>
Public class projecttask
{
Public projecttask ()
{
//
// Todo: add the constructor logic here
//
}
# region addactivitytorole
///
/// addactivitytorole
///
///
//
//
Public static void addactivitytorole (INT _ roleid, string _ activityname)
{< br> try
{< br> system. data. sqlclient. sqlparameter [] PS = new sqlparameter [] {
New sqlparameter ("@ iv_roleid", sqldbtype. int, 4),
New sqlparameter ("@ iv_activityname", sqldbtype. varchar, 50),
};
PS [0]. value = _ roleid;
PS [1]. value = _ activityname;
Sqlhelper. executenonquery (sqlhelper. conn_string, commandtype. storedprocedure, "addactivitytorole", PS );
}
Catch (system. Data. sqlclient. sqlexception ex)
{
Throw ex;
}
}
# Endregion addactivitytorole
# Region getuserlist
/// <Summary>
/// Getuserlist
/// </Summary>
/// <Returns> </returns>
Public static dataset getuserlist ()
{
Try
{
System. Data. sqlclient. sqlparameter [] PS = new sqlparameter [] {
};
Return sqlhelper. executedataset (sqlhelper. conn_string, commandtype. storedprocedure, "getuserlist", PS );
}
Catch (system. Data. sqlclient. sqlexception ex)
{
Throw ex;
}
}
# Endregion getuserlist
# region updatecharge
///
// updatecharge
///
///
//
//
//
Public static void updatecharge (string _ typename, string _ value, int _ chargeid)
{< br> try
{< br> system. data. sqlclient. sqlparameter [] PS = new sqlparameter [] {
New sqlparameter ("@ iv_typename", sqldbtype. varchar, 50),
New sqlparameter ("@ iv_value", sqldbtype. varchar, 8),
New sqlparameter ("@ iv_chargeid", sqldbtype. int, 4),
};
PS [0]. value = _ typename;
PS [1]. value = _ value;
PS [2]. value = _ chargeid;
Sqlhelper. executenonquery (sqlhelper. conn_string, commandtype. storedprocedure, "updatecharge", PS );
}
Catch (system. Data. sqlclient. sqlexception ex)
{
Throw ex;
}
}
# Endregion updatecharge
}
}
Interested in: edobnet@163.com