/// <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;
}
