/// <summary>
/// 分配职责
/// </summary>
/// <param name="lsUserDuty">用户职责</param>
/// <returns></returns>
public static string LicendToUser(UserDuty[] userdutys)
{
string result = "0";
DBOperate db = new DBOperate("DADB");
db.BeginTransaction();
try
{
StringBuilder sb = new StringBuilder();
int count = userdutys.Length;
string UserDutyId = Guid.NewGuid().ToString();
if (count > 1)
{
sb.Append("begin ");
for (int i = 0; i < count; i++)
{
UserDutyId = Guid.NewGuid().ToString();
sb.Append(string.Format("insert into UserDuty(USERDUTYID,UserID,DutyID) values('{0}','{1}','{2}');", UserDutyId, userdutys[i].UserID, userdutys[i].DutyID));
}
sb.Append(" end;");
}
else
{
sb.Append(string.Format("insert into UserDuty(USERDUTYID,UserID,DutyID) values('{0}','{1}','{2}')", UserDutyId, userdutys[0].UserID, userdutys[0].DutyID));
}
db.RunSqlNonQuery(sb.ToString());
db.Commit();
result = "1";
}
catch (Exception ex)
{
db.Rollback();
throw new Exception(ex.ToString());
}
finally
{
db.Despose();
}
return(result);
}
/// <summary>
/// 根据编号移除用户职责
/// </summary>
/// <param name="UserDutyIDs">编号</param>
/// <returns></returns>
public static string RemoveDuty(string[] UserDutyIDs)
{
string result = "0";
DBOperate db = new DBOperate("DADB");
db.BeginTransaction();
int count = UserDutyIDs.Length;
try
{
StringBuilder sb = new StringBuilder();
if (count > 0)
{
sb.Append("begin ");
for (int i = 0; i < count; i++)
{
sb.Append(string.Format("delete from UserDuty where UserDutyID='{0}';", UserDutyIDs[i]));
}
sb.Append(" end;");
}
else
{
sb.Append(string.Format("delete from UserDuty where UserDutyID='{0}'", UserDutyIDs[0]));
}
db.RunSqlNonQuery(sb.ToString());
result = "1";
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
throw new Exception(ex.ToString());
}
finally
{
db.Despose();
}
return(result);
}