/// <summary>
/// 得到一个对象实体
/// </summary>
public Mall.Model.user GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,DEPTID,ROLEID,USERNAME,LOGINNAME,SEX,USERTYPE,EMAIL,TEL,MOBILE,PWD,VALIDFLAG,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME,AGE,USERNAMEPY,HosNum from tb_user ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 32)
};
parameters[0].Value = ID;
Mall.Model.user model = new Mall.Model.user();
DataSet ds = DbHelperSQL.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(Mall.Model.user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_user(");
strSql.Append("ID,DEPTID,ROLEID,USERNAME,LOGINNAME,SEX,USERTYPE,EMAIL,TEL,MOBILE,PWD,VALIDFLAG,CREATEUSER,CREATETIME,UPDATEUSER,UPDATETIME,AGE,USERNAMEPY,HosNum)");
strSql.Append(" values (");
strSql.Append("@ID,@DEPTID,@ROLEID,@USERNAME,@LOGINNAME,@SEX,@USERTYPE,@EMAIL,@TEL,@MOBILE,@PWD,@VALIDFLAG,@CREATEUSER,@CREATETIME,@UPDATEUSER,@UPDATETIME,@AGE,@USERNAMEPY,@HosNum)");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 32),
new SqlParameter("@DEPTID", SqlDbType.NVarChar, 32),
new SqlParameter("@ROLEID", SqlDbType.NVarChar, 32),
new SqlParameter("@USERNAME", SqlDbType.NVarChar, 40),
new SqlParameter("@LOGINNAME", SqlDbType.NVarChar, 40),
new SqlParameter("@SEX", SqlDbType.Char, 1),
new SqlParameter("@USERTYPE", SqlDbType.Char, 1),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 40),
new SqlParameter("@TEL", SqlDbType.NVarChar, 20),
new SqlParameter("@MOBILE", SqlDbType.NVarChar, 20),
new SqlParameter("@PWD", SqlDbType.NVarChar, 100),
new SqlParameter("@VALIDFLAG", SqlDbType.Char, 1),
new SqlParameter("@CREATEUSER", SqlDbType.NVarChar, 40),
new SqlParameter("@CREATETIME", SqlDbType.DateTime),
new SqlParameter("@UPDATEUSER", SqlDbType.NVarChar, 40),
new SqlParameter("@UPDATETIME", SqlDbType.DateTime),
new SqlParameter("@AGE", SqlDbType.Int, 4),
new SqlParameter("@USERNAMEPY", SqlDbType.NVarChar, 40),
new SqlParameter("@HosNum", SqlDbType.NVarChar, 20)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.DEPTID;
parameters[2].Value = model.ROLEID;
parameters[3].Value = model.USERNAME;
parameters[4].Value = model.LOGINNAME;
parameters[5].Value = model.SEX;
parameters[6].Value = model.USERTYPE;
parameters[7].Value = model.EMAIL;
parameters[8].Value = model.TEL;
parameters[9].Value = model.MOBILE;
parameters[10].Value = model.PWD;
parameters[11].Value = model.VALIDFLAG;
parameters[12].Value = model.CREATEUSER;
parameters[13].Value = model.CREATETIME;
parameters[14].Value = model.UPDATEUSER;
parameters[15].Value = model.UPDATETIME;
parameters[16].Value = model.AGE;
parameters[17].Value = model.USERNAMEPY;
parameters[18].Value = model.HosNum;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mall.Model.user DataRowToModel(DataRow row)
{
Mall.Model.user model = new Mall.Model.user();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["DEPTID"] != null)
{
model.DEPTID = row["DEPTID"].ToString();
}
if (row["ROLEID"] != null)
{
model.ROLEID = row["ROLEID"].ToString();
}
if (row["USERNAME"] != null)
{
model.USERNAME = row["USERNAME"].ToString();
}
if (row["LOGINNAME"] != null)
{
model.LOGINNAME = row["LOGINNAME"].ToString();
}
if (row["SEX"] != null)
{
model.SEX = row["SEX"].ToString();
}
if (row["USERTYPE"] != null)
{
model.USERTYPE = row["USERTYPE"].ToString();
}
if (row["EMAIL"] != null)
{
model.EMAIL = row["EMAIL"].ToString();
}
if (row["TEL"] != null)
{
model.TEL = row["TEL"].ToString();
}
if (row["MOBILE"] != null)
{
model.MOBILE = row["MOBILE"].ToString();
}
if (row["PWD"] != null)
{
model.PWD = row["PWD"].ToString();
}
if (row["VALIDFLAG"] != null)
{
model.VALIDFLAG = row["VALIDFLAG"].ToString();
}
if (row["CREATEUSER"] != null)
{
model.CREATEUSER = row["CREATEUSER"].ToString();
}
if (row["CREATETIME"] != null && row["CREATETIME"].ToString() != "")
{
model.CREATETIME = DateTime.Parse(row["CREATETIME"].ToString());
}
if (row["UPDATEUSER"] != null)
{
model.UPDATEUSER = row["UPDATEUSER"].ToString();
}
if (row["UPDATETIME"] != null && row["UPDATETIME"].ToString() != "")
{
model.UPDATETIME = DateTime.Parse(row["UPDATETIME"].ToString());
}
if (row["AGE"] != null && row["AGE"].ToString() != "")
{
model.AGE = int.Parse(row["AGE"].ToString());
}
if (row["USERNAMEPY"] != null)
{
model.USERNAMEPY = row["USERNAMEPY"].ToString();
}
if (row["HosNum"] != null)
{
model.HosNum = row["HosNum"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mall.Model.user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_user set ");
strSql.Append("DEPTID=@DEPTID,");
strSql.Append("ROLEID=@ROLEID,");
strSql.Append("USERNAME=@USERNAME,");
strSql.Append("LOGINNAME=@LOGINNAME,");
strSql.Append("SEX=@SEX,");
strSql.Append("USERTYPE=@USERTYPE,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("TEL=@TEL,");
strSql.Append("MOBILE=@MOBILE,");
strSql.Append("PWD=@PWD,");
strSql.Append("VALIDFLAG=@VALIDFLAG,");
strSql.Append("CREATEUSER=@CREATEUSER,");
strSql.Append("CREATETIME=@CREATETIME,");
strSql.Append("UPDATEUSER=@UPDATEUSER,");
strSql.Append("UPDATETIME=@UPDATETIME,");
strSql.Append("AGE=@AGE,");
strSql.Append("USERNAMEPY=@USERNAMEPY,");
strSql.Append("HosNum=@HosNum");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@DEPTID", SqlDbType.NVarChar, 32),
new SqlParameter("@ROLEID", SqlDbType.NVarChar, 32),
new SqlParameter("@USERNAME", SqlDbType.NVarChar, 40),
new SqlParameter("@LOGINNAME", SqlDbType.NVarChar, 40),
new SqlParameter("@SEX", SqlDbType.Char, 1),
new SqlParameter("@USERTYPE", SqlDbType.Char, 1),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 40),
new SqlParameter("@TEL", SqlDbType.NVarChar, 20),
new SqlParameter("@MOBILE", SqlDbType.NVarChar, 20),
new SqlParameter("@PWD", SqlDbType.NVarChar, 100),
new SqlParameter("@VALIDFLAG", SqlDbType.Char, 1),
new SqlParameter("@CREATEUSER", SqlDbType.NVarChar, 40),
new SqlParameter("@CREATETIME", SqlDbType.DateTime),
new SqlParameter("@UPDATEUSER", SqlDbType.NVarChar, 40),
new SqlParameter("@UPDATETIME", SqlDbType.DateTime),
new SqlParameter("@AGE", SqlDbType.Int, 4),
new SqlParameter("@USERNAMEPY", SqlDbType.NVarChar, 40),
new SqlParameter("@HosNum", SqlDbType.NVarChar, 20),
new SqlParameter("@ID", SqlDbType.NVarChar, 32)
};
parameters[0].Value = model.DEPTID;
parameters[1].Value = model.ROLEID;
parameters[2].Value = model.USERNAME;
parameters[3].Value = model.LOGINNAME;
parameters[4].Value = model.SEX;
parameters[5].Value = model.USERTYPE;
parameters[6].Value = model.EMAIL;
parameters[7].Value = model.TEL;
parameters[8].Value = model.MOBILE;
parameters[9].Value = model.PWD;
parameters[10].Value = model.VALIDFLAG;
parameters[11].Value = model.CREATEUSER;
parameters[12].Value = model.CREATETIME;
parameters[13].Value = model.UPDATEUSER;
parameters[14].Value = model.UPDATETIME;
parameters[15].Value = model.AGE;
parameters[16].Value = model.USERNAMEPY;
parameters[17].Value = model.HosNum;
parameters[18].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
