/// <summary> /// 增加 /// </summary> /// <param name="fun"></param> /// <returns></returns> public int Add(CommandSendee fun) { string sql = string.Format("insert into CMT_CommandSendee(CommandID,UserID,State,CreateTime,IsDel) values ({0},{1},{2},@createTime,{3})", fun.CommandID, fun.UserID, fun.State, fun.IsDel); SqlParameter[] pms = { //new SqlParameter("@commandID",fun.CommandID ), //new SqlParameter("@userID",fun.UserID), //new SqlParameter("@state",fun.State), new SqlParameter("@createTime", fun.CreateTime) //new SqlParameter("@isDel",fun.IsDel) }; return((int)DBHelper.ExecuteNonQuery(sql, type, pms)); }
protected void Page_Load(object sender, EventArgs e) { //处理添加任务 if (Request["taID"] != null && Request["reID"] != null) { userBll bll = new userBll(); login = bll.GetByID(Convert.ToInt32(Request["reID"])); //创建并实例化一个CommandSendee对象 CommandSendee cs = new CommandSendee(); cs.CommandID = Convert.ToInt32(Request["taID"]); cs.UserID = Convert.ToInt32(Request["reID"]); cs.State = 1; cs.CreateTime = DateTime.Now; cs.IsDel = 0; //插入到数据库中 TaskSendeeBll bll2 = new TaskSendeeBll(); int rows = bll2.Add(cs); //返回受影响的行数 Response.Clear(); Response.ContentType = "text/plain"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Write(rows); Response.End(); } //处理该网评员还没有被分配的任务 if (Request["method"] != null) { //获取该网评员还没有被分配的任务 ReceiverBll bll = new ReceiverBll(); DataTable dt = bll.GetRestTask(Convert.ToInt32(Request["receiverID"])); DataSet set = new DataSet(); set.Tables.Add(dt); string json = JsonConvert.SerializeObject(set); //写回该网评员还没有被分配的任务 Response.Clear(); Response.ContentType = "text/plain"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Write(json); Response.End(); } //处理用户ID和用户名 if (Request["id"] != null) { GetData(); } }
/// <summary> ///增加 /// </summary> /// <param name="role"></param> /// <returns></returns> public int Add(CommandSendee task) { return(dal.Add(task)); }
//添加 public int Add(CommandSendee cs) { string sql = string.Format("insert into CMT_CommandSendee(CommandID,UserID,State,CreateTime,IsDel) values({0},{1},{2},{3}),{4}", cs.CommandID, cs.UserID, cs.State, cs.CreateTime, cs.IsDel); return(DBHelper.ExecuteNonQuery(sql, type)); }