public bool Add(Model_SysUserTask model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SysUserTask(");
builder.Append("SysUserTask_id,SysUser_ID,TaskType,TaskID,TaskName,CreateTime,CreateUser)");
builder.Append(" values (");
builder.Append("@SysUserTask_id,@SysUser_ID,@TaskType,@TaskID,@TaskName,@CreateTime,@CreateUser)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysUserTask_id", SqlDbType.Char, 0x24), new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@TaskType", SqlDbType.VarChar, 20), new SqlParameter("@TaskID", SqlDbType.VarChar, 0x24), new SqlParameter("@TaskName", SqlDbType.NVarChar, 250), new SqlParameter("@CreateTime", SqlDbType.DateTime, 3), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysUserTask_id;
cmdParms[1].Value = model.SysUser_ID;
cmdParms[2].Value = model.TaskType;
cmdParms[3].Value = model.TaskID;
cmdParms[4].Value = model.TaskName;
cmdParms[5].Value = model.CreateTime;
cmdParms[6].Value = model.CreateUser;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <Model_SysUserTask> DataTableToList(DataTable dt)
{
List <Model_SysUserTask> list = new List <Model_SysUserTask>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SysUserTask item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Update(Model_SysUserTask model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SysUserTask set ");
builder.Append("SysUser_ID=@SysUser_ID,");
builder.Append("TaskType=@TaskType,");
builder.Append("TaskID=@TaskID,");
builder.Append("TaskName=@TaskName,");
builder.Append("CreateTime=@CreateTime,");
builder.Append("CreateUser=@CreateUser");
builder.Append(" where SysUserTask_id=@SysUserTask_id ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysUser_ID", SqlDbType.Char, 0x24), new SqlParameter("@TaskType", SqlDbType.VarChar, 20), new SqlParameter("@TaskID", SqlDbType.VarChar, 0x24), new SqlParameter("@TaskName", SqlDbType.NVarChar, 250), new SqlParameter("@CreateTime", SqlDbType.DateTime, 3), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@SysUserTask_id", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SysUser_ID;
cmdParms[1].Value = model.TaskType;
cmdParms[2].Value = model.TaskID;
cmdParms[3].Value = model.TaskName;
cmdParms[4].Value = model.CreateTime;
cmdParms[5].Value = model.CreateUser;
cmdParms[6].Value = model.SysUserTask_id;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_SysUserTask DataRowToModel(DataRow row)
{
Model_SysUserTask task = new Model_SysUserTask();
if (row != null)
{
if (row["SysUserTask_id"] != null)
{
task.SysUserTask_id = row["SysUserTask_id"].ToString();
}
if (row["SysUser_ID"] != null)
{
task.SysUser_ID = row["SysUser_ID"].ToString();
}
if (row["TaskType"] != null)
{
task.TaskType = row["TaskType"].ToString();
}
if (row["TaskID"] != null)
{
task.TaskID = row["TaskID"].ToString();
}
if (row["TaskName"] != null)
{
task.TaskName = row["TaskName"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
task.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if (row["CreateUser"] != null)
{
task.CreateUser = row["CreateUser"].ToString();
}
}
return(task);
}
public bool Add(Model_SysUserTask model)
{
return(this.dal.Add(model));
}
public bool Update(Model_SysUserTask model)
{
return(this.dal.Update(model));
}
public static string TaskingSave(string targetUser, string nf, string njxq, string jcbb, string xk)
{
try
{
List <Model_SysUserTask> list = new List <Model_SysUserTask>();
Model_SysUserTask model = new Model_SysUserTask();
string[] strArrNF = nf.Split(',');
string[] strArrNJXQ = njxq.Split(',');
string[] strArrJCBB = jcbb.Split(',');
string[] strArrXK = xk.Split(',');
for (int i = 0; i < strArrNF.Length; i++)
{
string[] strObj = strArrNF[i].Split('|');
model = new Model_SysUserTask();
model.SysUserTask_id = Guid.NewGuid().ToString();
model.SysUser_ID = targetUser;
model.TaskType = "NF";
model.TaskID = strObj[0];
model.TaskName = strObj[1];
model.CreateTime = DateTime.Now;
model.CreateUser = modelLoginUser.SysUser_ID;
list.Add(model);
}
for (int i = 0; i < strArrNJXQ.Length; i++)
{
string[] strObj = strArrNJXQ[i].Split('|');
model = new Model_SysUserTask();
model.SysUserTask_id = Guid.NewGuid().ToString();
model.SysUser_ID = targetUser;
model.TaskType = "NJXQ";
model.TaskID = strObj[0];
model.TaskName = strObj[1];
model.CreateTime = DateTime.Now;
model.CreateUser = modelLoginUser.SysUser_ID;
list.Add(model);
}
for (int i = 0; i < strArrJCBB.Length; i++)
{
string[] strObj = strArrJCBB[i].Split('|');
model = new Model_SysUserTask();
model.SysUserTask_id = Guid.NewGuid().ToString();
model.SysUser_ID = targetUser;
model.TaskType = "JCBB";
model.TaskID = strObj[0];
model.TaskName = strObj[1];
model.CreateTime = DateTime.Now;
model.CreateUser = modelLoginUser.SysUser_ID;
list.Add(model);
}
for (int i = 0; i < strArrXK.Length; i++)
{
string[] strObj = strArrXK[i].Split('|');
model = new Model_SysUserTask();
model.SysUserTask_id = Guid.NewGuid().ToString();
model.SysUser_ID = targetUser;
model.TaskType = "XK";
model.TaskID = strObj[0];
model.TaskName = strObj[1];
model.CreateTime = DateTime.Now;
model.CreateUser = modelLoginUser.SysUser_ID;
list.Add(model);
}
if (new BLL_SysUserTask().TaskAllocation(list, targetUser, modelLoginUser.SysUser_ID) > 0)
{
return("1");
}
else
{
return("0");
}
}
catch (Exception ex)
{
return("0");
}
}
