public bool Update(Model_StatRes_Doc_Attr model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update StatRes_Doc_Attr set ");
builder.Append("SYear=@SYear,");
builder.Append("SDocType=@SDocType,");
builder.Append("SDocTypeName=@SDocTypeName,");
builder.Append("SAttrType=@SAttrType,");
builder.Append("SData_ID=@SData_ID,");
builder.Append("SData_Name=@SData_Name,");
builder.Append("SProductionCount=@SProductionCount,");
builder.Append("SDownloadCount=@SDownloadCount,");
builder.Append("SSaleCount=@SSaleCount,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where ID=@ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SYear", SqlDbType.Int, 4), new SqlParameter("@SDocType", SqlDbType.Char, 0x24), new SqlParameter("@SDocTypeName", SqlDbType.NVarChar, 100), new SqlParameter("@SAttrType", SqlDbType.VarChar, 30), new SqlParameter("@SData_ID", SqlDbType.Char, 0x24), new SqlParameter("@SData_Name", SqlDbType.VarChar, 250), new SqlParameter("@SProductionCount", SqlDbType.Int, 4), new SqlParameter("@SDownloadCount", SqlDbType.Int, 4), new SqlParameter("@SSaleCount", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.SYear;
cmdParms[1].Value = model.SDocType;
cmdParms[2].Value = model.SDocTypeName;
cmdParms[3].Value = model.SAttrType;
cmdParms[4].Value = model.SData_ID;
cmdParms[5].Value = model.SData_Name;
cmdParms[6].Value = model.SProductionCount;
cmdParms[7].Value = model.SDownloadCount;
cmdParms[8].Value = model.SSaleCount;
cmdParms[9].Value = model.CreateTime;
cmdParms[10].Value = model.ID;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public Model_StatRes_Doc_Attr DataRowToModel(DataRow row)
{
Model_StatRes_Doc_Attr attr = new Model_StatRes_Doc_Attr();
if (row != null)
{
if (row["ID"] != null)
{
attr.ID = row["ID"].ToString();
}
if ((row["SYear"] != null) && (row["SYear"].ToString() != ""))
{
attr.SYear = new int?(int.Parse(row["SYear"].ToString()));
}
if (row["SDocType"] != null)
{
attr.SDocType = row["SDocType"].ToString();
}
if (row["SDocTypeName"] != null)
{
attr.SDocTypeName = row["SDocTypeName"].ToString();
}
if (row["SAttrType"] != null)
{
attr.SAttrType = row["SAttrType"].ToString();
}
if (row["SData_ID"] != null)
{
attr.SData_ID = row["SData_ID"].ToString();
}
if (row["SData_Name"] != null)
{
attr.SData_Name = row["SData_Name"].ToString();
}
if ((row["SProductionCount"] != null) && (row["SProductionCount"].ToString() != ""))
{
attr.SProductionCount = new int?(int.Parse(row["SProductionCount"].ToString()));
}
if ((row["SDownloadCount"] != null) && (row["SDownloadCount"].ToString() != ""))
{
attr.SDownloadCount = new int?(int.Parse(row["SDownloadCount"].ToString()));
}
if ((row["SSaleCount"] != null) && (row["SSaleCount"].ToString() != ""))
{
attr.SSaleCount = new int?(int.Parse(row["SSaleCount"].ToString()));
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
attr.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
}
return(attr);
}
public List <Model_StatRes_Doc_Attr> DataTableToList(DataTable dt)
{
List <Model_StatRes_Doc_Attr> list = new List <Model_StatRes_Doc_Attr>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_StatRes_Doc_Attr item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_StatRes_Doc_Attr model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into StatRes_Doc_Attr(");
builder.Append("ID,SYear,SDocType,SDocTypeName,SAttrType,SData_ID,SData_Name,SProductionCount,SDownloadCount,SSaleCount,CreateTime)");
builder.Append(" values (");
builder.Append("@ID,@SYear,@SDocType,@SDocTypeName,@SAttrType,@SData_ID,@SData_Name,@SProductionCount,@SDownloadCount,@SSaleCount,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Char, 0x24), new SqlParameter("@SYear", SqlDbType.Int, 4), new SqlParameter("@SDocType", SqlDbType.Char, 0x24), new SqlParameter("@SDocTypeName", SqlDbType.NVarChar, 100), new SqlParameter("@SAttrType", SqlDbType.VarChar, 30), new SqlParameter("@SData_ID", SqlDbType.Char, 0x24), new SqlParameter("@SData_Name", SqlDbType.VarChar, 250), new SqlParameter("@SProductionCount", SqlDbType.Int, 4), new SqlParameter("@SDownloadCount", SqlDbType.Int, 4), new SqlParameter("@SSaleCount", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.ID;
cmdParms[1].Value = model.SYear;
cmdParms[2].Value = model.SDocType;
cmdParms[3].Value = model.SDocTypeName;
cmdParms[4].Value = model.SAttrType;
cmdParms[5].Value = model.SData_ID;
cmdParms[6].Value = model.SData_Name;
cmdParms[7].Value = model.SProductionCount;
cmdParms[8].Value = model.SDownloadCount;
cmdParms[9].Value = model.SSaleCount;
cmdParms[10].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_StatRes_Doc_Attr model)
{
return(this.dal.Add(model));
}
public bool Update(Model_StatRes_Doc_Attr model)
{
return(this.dal.Update(model));
}
