/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.task_info GetModel(string TASK_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select TASK_ID,GUNARK_ID,UNIT_ID,TASK_STATUS,TASK_BIGTYPE,TASK_SMALLTYPE,TASK_PROPERTY,TASK_PLAN_BEGINTIME,TASK_PLAN_FINISHTIME,TASK_APPLY_USERID,TASK_APPLY_TIME,TASK_APPLY_REMARK,TASK_CHECK_USERID,TASK_CHECK_TIME,TASK_CHECK_REMARK,TASK_APPROVAL_USERID,TASK_APPROVAL_TIME,TASK_APPROVAL_REMARK,TASK_REAL_BEGINTIME,TASK_REAL_FINISHTIME,TASK_AFTERWARDS_HANDLE,TASK_AFTERWARDS_DESCRIPTION,TASK_AFTERWARDS_TIME,TASK_FLAG_TYPE,TAKE_GUNBULLET_ADMIN1,RETURN_GUNBULLET_ADMIN1,TAKE_GUNBULLET_ADMIN2,RETURN_GUNBULLET_ADMIN2 from gunark_task_info "); strSql.Append(" where TASK_ID=@TASK_ID "); MySqlParameter[] parameters = { new MySqlParameter("@TASK_ID", MySqlDbType.VarChar, 255) }; parameters[0].Value = TASK_ID; Gunark.Model.task_info model = new Gunark.Model.task_info(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Gunark.Model.task_info model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into gunark_task_info("); strSql.Append("TASK_ID,GUNARK_ID,UNIT_ID,TASK_STATUS,TASK_BIGTYPE,TASK_SMALLTYPE,TASK_PROPERTY,TASK_PLAN_BEGINTIME,TASK_PLAN_FINISHTIME,TASK_APPLY_USERID,TASK_APPLY_TIME,TASK_APPLY_REMARK,TASK_CHECK_USERID,TASK_CHECK_TIME,TASK_CHECK_REMARK,TASK_APPROVAL_USERID,TASK_APPROVAL_TIME,TASK_APPROVAL_REMARK,TASK_REAL_BEGINTIME,TASK_REAL_FINISHTIME,TASK_AFTERWARDS_HANDLE,TASK_AFTERWARDS_DESCRIPTION,TASK_AFTERWARDS_TIME,TASK_FLAG_TYPE,TAKE_GUNBULLET_ADMIN1,RETURN_GUNBULLET_ADMIN1,TAKE_GUNBULLET_ADMIN2,RETURN_GUNBULLET_ADMIN2)"); strSql.Append(" values ("); strSql.Append("@TASK_ID,@GUNARK_ID,@UNIT_ID,@TASK_STATUS,@TASK_BIGTYPE,@TASK_SMALLTYPE,@TASK_PROPERTY,@TASK_PLAN_BEGINTIME,@TASK_PLAN_FINISHTIME,@TASK_APPLY_USERID,@TASK_APPLY_TIME,@TASK_APPLY_REMARK,@TASK_CHECK_USERID,@TASK_CHECK_TIME,@TASK_CHECK_REMARK,@TASK_APPROVAL_USERID,@TASK_APPROVAL_TIME,@TASK_APPROVAL_REMARK,@TASK_REAL_BEGINTIME,@TASK_REAL_FINISHTIME,@TASK_AFTERWARDS_HANDLE,@TASK_AFTERWARDS_DESCRIPTION,@TASK_AFTERWARDS_TIME,@TASK_FLAG_TYPE,@TAKE_GUNBULLET_ADMIN1,@RETURN_GUNBULLET_ADMIN1,@TAKE_GUNBULLET_ADMIN2,@RETURN_GUNBULLET_ADMIN2)"); MySqlParameter[] parameters = { new MySqlParameter("@TASK_ID", MySqlDbType.VarChar, 255), new MySqlParameter("@GUNARK_ID", MySqlDbType.VarChar, 255), new MySqlParameter("@UNIT_ID", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_STATUS", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_BIGTYPE", MySqlDbType.Int32, 10), new MySqlParameter("@TASK_SMALLTYPE", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_PROPERTY", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_PLAN_BEGINTIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_PLAN_FINISHTIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPLY_USERID", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPLY_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPLY_REMARK", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_CHECK_USERID", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_CHECK_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_CHECK_REMARK", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPROVAL_USERID", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPROVAL_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_APPROVAL_REMARK", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_REAL_BEGINTIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_REAL_FINISHTIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_AFTERWARDS_HANDLE", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_AFTERWARDS_DESCRIPTION", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_AFTERWARDS_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@TASK_FLAG_TYPE", MySqlDbType.VarChar, 10), new MySqlParameter("@TAKE_GUNBULLET_ADMIN1", MySqlDbType.VarChar, 255), new MySqlParameter("@RETURN_GUNBULLET_ADMIN1", MySqlDbType.VarChar, 255), new MySqlParameter("@TAKE_GUNBULLET_ADMIN2", MySqlDbType.VarChar, 255), new MySqlParameter("@RETURN_GUNBULLET_ADMIN2", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.TASK_ID; parameters[1].Value = model.GUNARK_ID; parameters[2].Value = model.UNIT_ID; parameters[3].Value = model.TASK_STATUS; parameters[4].Value = model.TASK_BIGTYPE; parameters[5].Value = model.TASK_SMALLTYPE; parameters[6].Value = model.TASK_PROPERTY; parameters[7].Value = model.TASK_PLAN_BEGINTIME; parameters[8].Value = model.TASK_PLAN_FINISHTIME; parameters[9].Value = model.TASK_APPLY_USERID; parameters[10].Value = model.TASK_APPLY_TIME; parameters[11].Value = model.TASK_APPLY_REMARK; parameters[12].Value = model.TASK_CHECK_USERID; parameters[13].Value = model.TASK_CHECK_TIME; parameters[14].Value = model.TASK_CHECK_REMARK; parameters[15].Value = model.TASK_APPROVAL_USERID; parameters[16].Value = model.TASK_APPROVAL_TIME; parameters[17].Value = model.TASK_APPROVAL_REMARK; parameters[18].Value = model.TASK_REAL_BEGINTIME; parameters[19].Value = model.TASK_REAL_FINISHTIME; parameters[20].Value = model.TASK_AFTERWARDS_HANDLE; parameters[21].Value = model.TASK_AFTERWARDS_DESCRIPTION; parameters[22].Value = model.TASK_AFTERWARDS_TIME; parameters[23].Value = model.TASK_FLAG_TYPE; parameters[24].Value = model.TAKE_GUNBULLET_ADMIN1; parameters[25].Value = model.RETURN_GUNBULLET_ADMIN1; parameters[26].Value = model.TAKE_GUNBULLET_ADMIN2; parameters[27].Value = model.RETURN_GUNBULLET_ADMIN2; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.task_info DataRowToModel(DataRow row) { Gunark.Model.task_info model = new Gunark.Model.task_info(); if (row != null) { if (row["TASK_ID"] != null) { model.TASK_ID = row["TASK_ID"].ToString(); } if (row["GUNARK_ID"] != null) { model.GUNARK_ID = row["GUNARK_ID"].ToString(); } if (row["UNIT_ID"] != null) { model.UNIT_ID = row["UNIT_ID"].ToString(); } if (row["TASK_STATUS"] != null) { model.TASK_STATUS = row["TASK_STATUS"].ToString(); } if (row["TASK_BIGTYPE"] != null && row["TASK_BIGTYPE"].ToString() != "") { model.TASK_BIGTYPE = int.Parse(row["TASK_BIGTYPE"].ToString()); } if (row["TASK_SMALLTYPE"] != null) { model.TASK_SMALLTYPE = row["TASK_SMALLTYPE"].ToString(); } if (row["TASK_PROPERTY"] != null) { model.TASK_PROPERTY = row["TASK_PROPERTY"].ToString(); } if (row["TASK_PLAN_BEGINTIME"] != null) { model.TASK_PLAN_BEGINTIME = row["TASK_PLAN_BEGINTIME"].ToString(); } if (row["TASK_PLAN_FINISHTIME"] != null) { model.TASK_PLAN_FINISHTIME = row["TASK_PLAN_FINISHTIME"].ToString(); } if (row["TASK_APPLY_USERID"] != null) { model.TASK_APPLY_USERID = row["TASK_APPLY_USERID"].ToString(); } if (row["TASK_APPLY_TIME"] != null) { model.TASK_APPLY_TIME = row["TASK_APPLY_TIME"].ToString(); } if (row["TASK_APPLY_REMARK"] != null) { model.TASK_APPLY_REMARK = row["TASK_APPLY_REMARK"].ToString(); } if (row["TASK_CHECK_USERID"] != null) { model.TASK_CHECK_USERID = row["TASK_CHECK_USERID"].ToString(); } if (row["TASK_CHECK_TIME"] != null) { model.TASK_CHECK_TIME = row["TASK_CHECK_TIME"].ToString(); } if (row["TASK_CHECK_REMARK"] != null) { model.TASK_CHECK_REMARK = row["TASK_CHECK_REMARK"].ToString(); } if (row["TASK_APPROVAL_USERID"] != null) { model.TASK_APPROVAL_USERID = row["TASK_APPROVAL_USERID"].ToString(); } if (row["TASK_APPROVAL_TIME"] != null) { model.TASK_APPROVAL_TIME = row["TASK_APPROVAL_TIME"].ToString(); } if (row["TASK_APPROVAL_REMARK"] != null) { model.TASK_APPROVAL_REMARK = row["TASK_APPROVAL_REMARK"].ToString(); } if (row["TASK_REAL_BEGINTIME"] != null) { model.TASK_REAL_BEGINTIME = row["TASK_REAL_BEGINTIME"].ToString(); } if (row["TASK_REAL_FINISHTIME"] != null) { model.TASK_REAL_FINISHTIME = row["TASK_REAL_FINISHTIME"].ToString(); } if (row["TASK_AFTERWARDS_HANDLE"] != null) { model.TASK_AFTERWARDS_HANDLE = row["TASK_AFTERWARDS_HANDLE"].ToString(); } if (row["TASK_AFTERWARDS_DESCRIPTION"] != null) { model.TASK_AFTERWARDS_DESCRIPTION = row["TASK_AFTERWARDS_DESCRIPTION"].ToString(); } if (row["TASK_AFTERWARDS_TIME"] != null) { model.TASK_AFTERWARDS_TIME = row["TASK_AFTERWARDS_TIME"].ToString(); } if (row["TASK_FLAG_TYPE"] != null) { model.TASK_FLAG_TYPE = row["TASK_FLAG_TYPE"].ToString(); } if (row["TAKE_GUNBULLET_ADMIN1"] != null) { model.TAKE_GUNBULLET_ADMIN1 = row["TAKE_GUNBULLET_ADMIN1"].ToString(); } if (row["RETURN_GUNBULLET_ADMIN1"] != null) { model.RETURN_GUNBULLET_ADMIN1 = row["RETURN_GUNBULLET_ADMIN1"].ToString(); } if (row["TAKE_GUNBULLET_ADMIN2"] != null) { model.TAKE_GUNBULLET_ADMIN2 = row["TAKE_GUNBULLET_ADMIN2"].ToString(); } if (row["RETURN_GUNBULLET_ADMIN2"] != null) { model.RETURN_GUNBULLET_ADMIN2 = row["RETURN_GUNBULLET_ADMIN2"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.task_info GetModel(string TASK_ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select TASK_ID,GUNARK_ID,UNIT_ID,TASK_STATUS,TASK_BIGTYPE,TASK_SMALLTYPE,TASK_PROPERTY,TASK_PLAN_BEGINTIME,TASK_PLAN_FINISHTIME,TASK_APPLY_USERID,TASK_APPLY_TIME,TASK_APPLY_REMARK,TASK_CHECK_USERID,TASK_CHECK_TIME,TASK_CHECK_REMARK,TASK_APPROVAL_USERID,TASK_APPROVAL_TIME,TASK_APPROVAL_REMARK,TASK_REAL_BEGINTIME,TASK_REAL_FINISHTIME,TASK_AFTERWARDS_HANDLE,TASK_AFTERWARDS_DESCRIPTION,TASK_AFTERWARDS_TIME,TASK_FLAG_TYPE,TAKE_GUNBULLET_ADMIN1,RETURN_GUNBULLET_ADMIN1,TAKE_GUNBULLET_ADMIN2,RETURN_GUNBULLET_ADMIN2 from gunark_task_info "); strSql.Append(" where TASK_ID=@TASK_ID "); MySqlParameter[] parameters = { new MySqlParameter("@TASK_ID", MySqlDbType.VarChar,255) }; parameters[0].Value = TASK_ID; Gunark.Model.task_info model=new Gunark.Model.task_info(); DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.task_info DataRowToModel(DataRow row) { Gunark.Model.task_info model=new Gunark.Model.task_info(); if (row != null) { if(row["TASK_ID"]!=null) { model.TASK_ID=row["TASK_ID"].ToString(); } if(row["GUNARK_ID"]!=null) { model.GUNARK_ID=row["GUNARK_ID"].ToString(); } if(row["UNIT_ID"]!=null) { model.UNIT_ID=row["UNIT_ID"].ToString(); } if(row["TASK_STATUS"]!=null) { model.TASK_STATUS=row["TASK_STATUS"].ToString(); } if(row["TASK_BIGTYPE"]!=null && row["TASK_BIGTYPE"].ToString()!="") { model.TASK_BIGTYPE=int.Parse(row["TASK_BIGTYPE"].ToString()); } if(row["TASK_SMALLTYPE"]!=null) { model.TASK_SMALLTYPE=row["TASK_SMALLTYPE"].ToString(); } if(row["TASK_PROPERTY"]!=null) { model.TASK_PROPERTY=row["TASK_PROPERTY"].ToString(); } if(row["TASK_PLAN_BEGINTIME"]!=null) { model.TASK_PLAN_BEGINTIME=row["TASK_PLAN_BEGINTIME"].ToString(); } if(row["TASK_PLAN_FINISHTIME"]!=null) { model.TASK_PLAN_FINISHTIME=row["TASK_PLAN_FINISHTIME"].ToString(); } if(row["TASK_APPLY_USERID"]!=null) { model.TASK_APPLY_USERID=row["TASK_APPLY_USERID"].ToString(); } if(row["TASK_APPLY_TIME"]!=null) { model.TASK_APPLY_TIME=row["TASK_APPLY_TIME"].ToString(); } if(row["TASK_APPLY_REMARK"]!=null) { model.TASK_APPLY_REMARK=row["TASK_APPLY_REMARK"].ToString(); } if(row["TASK_CHECK_USERID"]!=null) { model.TASK_CHECK_USERID=row["TASK_CHECK_USERID"].ToString(); } if(row["TASK_CHECK_TIME"]!=null) { model.TASK_CHECK_TIME=row["TASK_CHECK_TIME"].ToString(); } if(row["TASK_CHECK_REMARK"]!=null) { model.TASK_CHECK_REMARK=row["TASK_CHECK_REMARK"].ToString(); } if(row["TASK_APPROVAL_USERID"]!=null) { model.TASK_APPROVAL_USERID=row["TASK_APPROVAL_USERID"].ToString(); } if(row["TASK_APPROVAL_TIME"]!=null) { model.TASK_APPROVAL_TIME=row["TASK_APPROVAL_TIME"].ToString(); } if(row["TASK_APPROVAL_REMARK"]!=null) { model.TASK_APPROVAL_REMARK=row["TASK_APPROVAL_REMARK"].ToString(); } if(row["TASK_REAL_BEGINTIME"]!=null) { model.TASK_REAL_BEGINTIME=row["TASK_REAL_BEGINTIME"].ToString(); } if(row["TASK_REAL_FINISHTIME"]!=null) { model.TASK_REAL_FINISHTIME=row["TASK_REAL_FINISHTIME"].ToString(); } if(row["TASK_AFTERWARDS_HANDLE"]!=null) { model.TASK_AFTERWARDS_HANDLE=row["TASK_AFTERWARDS_HANDLE"].ToString(); } if(row["TASK_AFTERWARDS_DESCRIPTION"]!=null) { model.TASK_AFTERWARDS_DESCRIPTION=row["TASK_AFTERWARDS_DESCRIPTION"].ToString(); } if(row["TASK_AFTERWARDS_TIME"]!=null) { model.TASK_AFTERWARDS_TIME=row["TASK_AFTERWARDS_TIME"].ToString(); } if(row["TASK_FLAG_TYPE"]!=null) { model.TASK_FLAG_TYPE=row["TASK_FLAG_TYPE"].ToString(); } if(row["TAKE_GUNBULLET_ADMIN1"]!=null) { model.TAKE_GUNBULLET_ADMIN1=row["TAKE_GUNBULLET_ADMIN1"].ToString(); } if(row["RETURN_GUNBULLET_ADMIN1"]!=null) { model.RETURN_GUNBULLET_ADMIN1=row["RETURN_GUNBULLET_ADMIN1"].ToString(); } if(row["TAKE_GUNBULLET_ADMIN2"]!=null) { model.TAKE_GUNBULLET_ADMIN2=row["TAKE_GUNBULLET_ADMIN2"].ToString(); } if(row["RETURN_GUNBULLET_ADMIN2"]!=null) { model.RETURN_GUNBULLET_ADMIN2=row["RETURN_GUNBULLET_ADMIN2"].ToString(); } } return model; }