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