/// <summary>
/// 得到一个对象实体（根据姓名）
/// </summary>
public Gunark.Model.user GetModelByName(string USER_REALNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select USER_ID,USER_POLICENUMB,USER_REALNAME,USER_NAME,USER_PWD,USER_STATE,USER_ADDRESS,USER_OFFICETELEP,USER_MOBILTELEP,USER_SEX,USER_EMAIL,USER_POSTCODE,USER_PRIVIEGES,USER_GUNLICENSE,USER_GUNLICENSEDATE,USER_POLICEKINDS,USER_RANK,USER_REMARK,USER_CARD,USER_JOBSTATUS,UNITINFO_CODE,USER_FINGER_ID,GROUP_ID,USER_BANNED from gunark_user ");
strSql.Append(" where USER_REALNAME=@USER_REALNAME ");
MySqlParameter[] parameters =
{
new MySqlParameter("@USER_REALNAME", MySqlDbType.VarChar, 255)
};
parameters[0].Value = USER_REALNAME;
Gunark.Model.user model = new Gunark.Model.user();
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.user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gunark_user(");
strSql.Append("USER_ID,USER_POLICENUMB,USER_REALNAME,USER_NAME,USER_PWD,USER_STATE,USER_ADDRESS,USER_OFFICETELEP,USER_MOBILTELEP,USER_SEX,USER_EMAIL,USER_POSTCODE,USER_PRIVIEGES,USER_GUNLICENSE,USER_GUNLICENSEDATE,USER_POLICEKINDS,USER_RANK,USER_REMARK,USER_CARD,USER_JOBSTATUS,UNITINFO_CODE,USER_FINGER_ID,GROUP_ID,USER_BANNED)");
strSql.Append(" values (");
strSql.Append("@USER_ID,@USER_POLICENUMB,@USER_REALNAME,@USER_NAME,@USER_PWD,@USER_STATE,@USER_ADDRESS,@USER_OFFICETELEP,@USER_MOBILTELEP,@USER_SEX,@USER_EMAIL,@USER_POSTCODE,@USER_PRIVIEGES,@USER_GUNLICENSE,@USER_GUNLICENSEDATE,@USER_POLICEKINDS,@USER_RANK,@USER_REMARK,@USER_CARD,@USER_JOBSTATUS,@UNITINFO_CODE,@USER_FINGER_ID,@GROUP_ID,@USER_BANNED)");
MySqlParameter[] parameters =
{
new MySqlParameter("@USER_ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_POLICENUMB", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_REALNAME", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_NAME", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_PWD", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_STATE", MySqlDbType.Int32, 10),
new MySqlParameter("@USER_ADDRESS", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_OFFICETELEP", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_MOBILTELEP", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_SEX", MySqlDbType.Int32, 10),
new MySqlParameter("@USER_EMAIL", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_POSTCODE", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_PRIVIEGES", MySqlDbType.Int32, 10),
new MySqlParameter("@USER_GUNLICENSE", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_GUNLICENSEDATE", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_POLICEKINDS", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_RANK", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_REMARK", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_CARD", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_JOBSTATUS", MySqlDbType.Int32, 1),
new MySqlParameter("@UNITINFO_CODE", MySqlDbType.VarChar, 255),
new MySqlParameter("@USER_FINGER_ID", MySqlDbType.VarChar, 255),
new MySqlParameter("@GROUP_ID", MySqlDbType.VarChar, 50),
new MySqlParameter("@USER_BANNED", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.USER_ID;
parameters[1].Value = model.USER_POLICENUMB;
parameters[2].Value = model.USER_REALNAME;
parameters[3].Value = model.USER_NAME;
parameters[4].Value = model.USER_PWD;
parameters[5].Value = model.USER_STATE;
parameters[6].Value = model.USER_ADDRESS;
parameters[7].Value = model.USER_OFFICETELEP;
parameters[8].Value = model.USER_MOBILTELEP;
parameters[9].Value = model.USER_SEX;
parameters[10].Value = model.USER_EMAIL;
parameters[11].Value = model.USER_POSTCODE;
parameters[12].Value = model.USER_PRIVIEGES;
parameters[13].Value = model.USER_GUNLICENSE;
parameters[14].Value = model.USER_GUNLICENSEDATE;
parameters[15].Value = model.USER_POLICEKINDS;
parameters[16].Value = model.USER_RANK;
parameters[17].Value = model.USER_REMARK;
parameters[18].Value = model.USER_CARD;
parameters[19].Value = model.USER_JOBSTATUS;
parameters[20].Value = model.UNITINFO_CODE;
parameters[21].Value = model.USER_FINGER_ID;
parameters[22].Value = model.GROUP_ID;
parameters[23].Value = model.USER_BANNED;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Gunark.Model.user DataRowToModel(DataRow row)
{
Gunark.Model.user model = new Gunark.Model.user();
if (row != null)
{
if (row["USER_ID"] != null)
{
model.USER_ID = row["USER_ID"].ToString();
}
if (row["USER_POLICENUMB"] != null)
{
model.USER_POLICENUMB = row["USER_POLICENUMB"].ToString();
}
if (row["USER_REALNAME"] != null)
{
model.USER_REALNAME = row["USER_REALNAME"].ToString();
}
if (row["USER_NAME"] != null)
{
model.USER_NAME = row["USER_NAME"].ToString();
}
if (row["USER_PWD"] != null)
{
model.USER_PWD = row["USER_PWD"].ToString();
}
if (row["USER_STATE"] != null && row["USER_STATE"].ToString() != "")
{
model.USER_STATE = int.Parse(row["USER_STATE"].ToString());
}
if (row["USER_ADDRESS"] != null)
{
model.USER_ADDRESS = row["USER_ADDRESS"].ToString();
}
if (row["USER_OFFICETELEP"] != null)
{
model.USER_OFFICETELEP = row["USER_OFFICETELEP"].ToString();
}
if (row["USER_MOBILTELEP"] != null)
{
model.USER_MOBILTELEP = row["USER_MOBILTELEP"].ToString();
}
if (row["USER_SEX"] != null && row["USER_SEX"].ToString() != "")
{
model.USER_SEX = int.Parse(row["USER_SEX"].ToString());
}
if (row["USER_EMAIL"] != null)
{
model.USER_EMAIL = row["USER_EMAIL"].ToString();
}
if (row["USER_POSTCODE"] != null)
{
model.USER_POSTCODE = row["USER_POSTCODE"].ToString();
}
if (row["USER_PRIVIEGES"] != null && row["USER_PRIVIEGES"].ToString() != "")
{
model.USER_PRIVIEGES = int.Parse(row["USER_PRIVIEGES"].ToString());
}
if (row["USER_GUNLICENSE"] != null)
{
model.USER_GUNLICENSE = row["USER_GUNLICENSE"].ToString();
}
if (row["USER_GUNLICENSEDATE"] != null)
{
model.USER_GUNLICENSEDATE = row["USER_GUNLICENSEDATE"].ToString();
}
if (row["USER_POLICEKINDS"] != null)
{
model.USER_POLICEKINDS = row["USER_POLICEKINDS"].ToString();
}
if (row["USER_RANK"] != null)
{
model.USER_RANK = row["USER_RANK"].ToString();
}
if (row["USER_REMARK"] != null)
{
model.USER_REMARK = row["USER_REMARK"].ToString();
}
if (row["USER_CARD"] != null)
{
model.USER_CARD = row["USER_CARD"].ToString();
}
if (row["USER_JOBSTATUS"] != null && row["USER_JOBSTATUS"].ToString() != "")
{
model.USER_JOBSTATUS = int.Parse(row["USER_JOBSTATUS"].ToString());
}
if (row["UNITINFO_CODE"] != null)
{
model.UNITINFO_CODE = row["UNITINFO_CODE"].ToString();
}
if (row["USER_FINGER_ID"] != null)
{
model.USER_FINGER_ID = row["USER_FINGER_ID"].ToString();
}
if (row["GROUP_ID"] != null)
{
model.GROUP_ID = row["GROUP_ID"].ToString();
}
if (row["USER_BANNED"] != null && row["USER_BANNED"].ToString() != "")
{
model.USER_BANNED = int.Parse(row["USER_BANNED"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体（根据姓名）
/// </summary>
public Gunark.Model.user GetModelByName(string USER_REALNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select USER_ID,USER_POLICENUMB,USER_REALNAME,USER_NAME,USER_PWD,USER_STATE,USER_ADDRESS,USER_OFFICETELEP,USER_MOBILTELEP,USER_SEX,USER_EMAIL,USER_POSTCODE,USER_PRIVIEGES,USER_GUNLICENSE,USER_GUNLICENSEDATE,USER_POLICEKINDS,USER_RANK,USER_REMARK,USER_CARD,USER_JOBSTATUS,UNITINFO_CODE,USER_FINGER_ID,GROUP_ID,USER_BANNED from gunark_user ");
strSql.Append(" where USER_REALNAME=@USER_REALNAME ");
MySqlParameter[] parameters = {
new MySqlParameter("@USER_REALNAME", MySqlDbType.VarChar,255) };
parameters[0].Value = USER_REALNAME;
Gunark.Model.user model = new Gunark.Model.user();
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.user DataRowToModel(DataRow row)
{
Gunark.Model.user model = new Gunark.Model.user();
if (row != null)
{
if (row["USER_ID"] != null)
{
model.USER_ID = row["USER_ID"].ToString();
}
if (row["USER_POLICENUMB"] != null)
{
model.USER_POLICENUMB = row["USER_POLICENUMB"].ToString();
}
if (row["USER_REALNAME"] != null)
{
model.USER_REALNAME = row["USER_REALNAME"].ToString();
}
if (row["USER_NAME"] != null)
{
model.USER_NAME = row["USER_NAME"].ToString();
}
if (row["USER_PWD"] != null)
{
model.USER_PWD = row["USER_PWD"].ToString();
}
if (row["USER_STATE"] != null && row["USER_STATE"].ToString() != "")
{
model.USER_STATE = int.Parse(row["USER_STATE"].ToString());
}
if (row["USER_ADDRESS"] != null)
{
model.USER_ADDRESS = row["USER_ADDRESS"].ToString();
}
if (row["USER_OFFICETELEP"] != null)
{
model.USER_OFFICETELEP = row["USER_OFFICETELEP"].ToString();
}
if (row["USER_MOBILTELEP"] != null)
{
model.USER_MOBILTELEP = row["USER_MOBILTELEP"].ToString();
}
if (row["USER_SEX"] != null && row["USER_SEX"].ToString() != "")
{
model.USER_SEX = int.Parse(row["USER_SEX"].ToString());
}
if (row["USER_EMAIL"] != null)
{
model.USER_EMAIL = row["USER_EMAIL"].ToString();
}
if (row["USER_POSTCODE"] != null)
{
model.USER_POSTCODE = row["USER_POSTCODE"].ToString();
}
if (row["USER_PRIVIEGES"] != null && row["USER_PRIVIEGES"].ToString() != "")
{
model.USER_PRIVIEGES = int.Parse(row["USER_PRIVIEGES"].ToString());
}
if (row["USER_GUNLICENSE"] != null)
{
model.USER_GUNLICENSE = row["USER_GUNLICENSE"].ToString();
}
if (row["USER_GUNLICENSEDATE"] != null)
{
model.USER_GUNLICENSEDATE = row["USER_GUNLICENSEDATE"].ToString();
}
if (row["USER_POLICEKINDS"] != null)
{
model.USER_POLICEKINDS = row["USER_POLICEKINDS"].ToString();
}
if (row["USER_RANK"] != null)
{
model.USER_RANK = row["USER_RANK"].ToString();
}
if (row["USER_REMARK"] != null)
{
model.USER_REMARK = row["USER_REMARK"].ToString();
}
if (row["USER_CARD"] != null)
{
model.USER_CARD = row["USER_CARD"].ToString();
}
if (row["USER_JOBSTATUS"] != null && row["USER_JOBSTATUS"].ToString() != "")
{
model.USER_JOBSTATUS = int.Parse(row["USER_JOBSTATUS"].ToString());
}
if (row["UNITINFO_CODE"] != null)
{
model.UNITINFO_CODE = row["UNITINFO_CODE"].ToString();
}
if (row["USER_FINGER_ID"] != null)
{
model.USER_FINGER_ID = row["USER_FINGER_ID"].ToString();
}
if (row["GROUP_ID"] != null)
{
model.GROUP_ID = row["GROUP_ID"].ToString();
}
if (row["USER_BANNED"] != null && row["USER_BANNED"].ToString() != "")
{
model.USER_BANNED = int.Parse(row["USER_BANNED"].ToString());
}
}
return model;
}
