/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TSGLXT.Model.GLB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GLB set ");
strSql.Append("ADYNAME=@ADYNAME,");
strSql.Append("ADSEX=@ADSEX,");
strSql.Append("SKID=@SKID,");
strSql.Append("ADPASSWORD=@ADPASSWORD");
strSql.Append(" where ADUSERNAME=@ADUSERNAME ");
SqlParameter[] parameters =
{
new SqlParameter("@ADYNAME", SqlDbType.VarChar, 10),
new SqlParameter("@ADSEX", SqlDbType.VarChar, 2),
new SqlParameter("@SKID", SqlDbType.VarChar, 6),
new SqlParameter("@ADPASSWORD", SqlDbType.VarChar, 10),
new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.ADYNAME;
parameters[1].Value = model.ADSEX;
parameters[2].Value = model.SKID;
parameters[3].Value = model.ADPASSWORD;
parameters[4].Value = model.ADUSERNAME;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSGLXT.Model.GLB DataRowToModel(DataRow row)
{
TSGLXT.Model.GLB model = new TSGLXT.Model.GLB();
if (row != null)
{
if (row["ADYNAME"] != null)
{
model.ADYNAME = row["ADYNAME"].ToString();
}
if (row["ADSEX"] != null)
{
model.ADSEX = row["ADSEX"].ToString();
}
if (row["ADUSERNAME"] != null)
{
model.ADUSERNAME = row["ADUSERNAME"].ToString();
}
if (row["SKID"] != null)
{
model.SKID = row["SKID"].ToString();
}
if (row["ADPASSWORD"] != null)
{
model.ADPASSWORD = row["ADPASSWORD"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TSGLXT.Model.GLB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GLB(");
strSql.Append("ADYNAME,ADSEX,ADUSERNAME,SKID,ADPASSWORD)");
strSql.Append(" values (");
strSql.Append("@ADYNAME,@ADSEX,@ADUSERNAME,@SKID,@ADPASSWORD)");
SqlParameter[] parameters =
{
new SqlParameter("@ADYNAME", SqlDbType.VarChar, 10),
new SqlParameter("@ADSEX", SqlDbType.VarChar, 2),
new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10),
new SqlParameter("@SKID", SqlDbType.VarChar, 6),
new SqlParameter("@ADPASSWORD", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.ADYNAME;
parameters[1].Value = model.ADSEX;
parameters[2].Value = model.ADUSERNAME;
parameters[3].Value = model.SKID;
parameters[4].Value = model.ADPASSWORD;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSGLXT.Model.GLB GetModel(string ADUSERNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ADYNAME,ADSEX,ADUSERNAME,SKID,ADPASSWORD from GLB ");
strSql.Append(" where ADUSERNAME=@ADUSERNAME ");
SqlParameter[] parameters =
{
new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10)
};
parameters[0].Value = ADUSERNAME;
TSGLXT.Model.GLB model = new TSGLXT.Model.GLB();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
