/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Gunark.Model.admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gunark_admin set ");
strSql.Append("ADMIN_KIND=@ADMIN_KIND,");
strSql.Append("ADMIN_DUTYBEGIN=@ADMIN_DUTYBEGIN,");
strSql.Append("ADMIN_DUTYEND=@ADMIN_DUTYEND,");
strSql.Append("ADMIN_STATUS=@ADMIN_STATUS,");
strSql.Append("USERID=@USERID,");
strSql.Append("ADMIN_ID=@ADMIN_ID");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ADMIN_KIND", MySqlDbType.VarChar, 10),
new MySqlParameter("@ADMIN_DUTYBEGIN", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_DUTYEND", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_STATUS", MySqlDbType.Int32, 10),
new MySqlParameter("@USERID", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@ID", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.ADMIN_KIND;
parameters[1].Value = model.ADMIN_DUTYBEGIN;
parameters[2].Value = model.ADMIN_DUTYEND;
parameters[3].Value = model.ADMIN_STATUS;
parameters[4].Value = model.USERID;
parameters[5].Value = model.ADMIN_ID;
parameters[6].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Gunark.Model.admin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_admin(");
strSql.Append("ID,ADMIN_KIND,ADMIN_DUTYBEGIN,ADMIN_DUTYEND,ADMIN_STATUS,USERID,ADMIN_ID)");
strSql.Append(" values (");
strSql.Append("@ID,@ADMIN_KIND,@ADMIN_DUTYBEGIN,@ADMIN_DUTYEND,@ADMIN_STATUS,@USERID,@ADMIN_ID)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_KIND", MySqlDbType.VarChar, 10),
new MySqlParameter("@ADMIN_DUTYBEGIN", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_DUTYEND", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_STATUS", MySqlDbType.Int32, 10),
new MySqlParameter("@USERID", MySqlDbType.VarChar, 255),
new MySqlParameter("@ADMIN_ID", MySqlDbType.VarChar, 255)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.ADMIN_KIND;
parameters[2].Value = model.ADMIN_DUTYBEGIN;
parameters[3].Value = model.ADMIN_DUTYEND;
parameters[4].Value = model.ADMIN_STATUS;
parameters[5].Value = model.USERID;
parameters[6].Value = model.ADMIN_ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Gunark.Model.admin DataRowToModel(DataRow row)
{
Gunark.Model.admin model = new Gunark.Model.admin();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["ADMIN_KIND"] != null)
{
model.ADMIN_KIND = row["ADMIN_KIND"].ToString();
}
if (row["ADMIN_DUTYBEGIN"] != null)
{
model.ADMIN_DUTYBEGIN = row["ADMIN_DUTYBEGIN"].ToString();
}
if (row["ADMIN_DUTYEND"] != null)
{
model.ADMIN_DUTYEND = row["ADMIN_DUTYEND"].ToString();
}
if (row["ADMIN_STATUS"] != null && row["ADMIN_STATUS"].ToString() != "")
{
model.ADMIN_STATUS = int.Parse(row["ADMIN_STATUS"].ToString());
}
if (row["USERID"] != null)
{
model.USERID = row["USERID"].ToString();
}
if (row["ADMIN_ID"] != null)
{
model.ADMIN_ID = row["ADMIN_ID"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Gunark.Model.admin GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,ADMIN_KIND,ADMIN_DUTYBEGIN,ADMIN_DUTYEND,ADMIN_STATUS,USERID,ADMIN_ID from gunark_admin ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 255)
};
parameters[0].Value = ID;
Gunark.Model.admin model = new Gunark.Model.admin();
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.admin DataRowToModel(DataRow row)
{
Gunark.Model.admin model=new Gunark.Model.admin();
if (row != null)
{
if(row["ID"]!=null)
{
model.ID=row["ID"].ToString();
}
if(row["ADMIN_KIND"]!=null)
{
model.ADMIN_KIND=row["ADMIN_KIND"].ToString();
}
if(row["ADMIN_DUTYBEGIN"]!=null)
{
model.ADMIN_DUTYBEGIN=row["ADMIN_DUTYBEGIN"].ToString();
}
if(row["ADMIN_DUTYEND"]!=null)
{
model.ADMIN_DUTYEND=row["ADMIN_DUTYEND"].ToString();
}
if(row["ADMIN_STATUS"]!=null && row["ADMIN_STATUS"].ToString()!="")
{
model.ADMIN_STATUS=int.Parse(row["ADMIN_STATUS"].ToString());
}
if(row["USERID"]!=null)
{
model.USERID=row["USERID"].ToString();
}
if(row["ADMIN_ID"]!=null)
{
model.ADMIN_ID=row["ADMIN_ID"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Gunark.Model.admin GetModel(string ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ID,ADMIN_KIND,ADMIN_DUTYBEGIN,ADMIN_DUTYEND,ADMIN_STATUS,USERID,ADMIN_ID from gunark_admin ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters = {
new MySqlParameter("@ID", MySqlDbType.VarChar,255) };
parameters[0].Value = ID;
Gunark.Model.admin model=new Gunark.Model.admin();
DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
