/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DBA.Model.ExaminationItme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ExaminationItme set ");
strSql.Append("Name=SQL2012Name,");
strSql.Append("NormalValue=SQL2012NormalValue,");
strSql.Append("DepartmentID=SQL2012DepartmentID,");
strSql.Append("Price=SQL2012Price,");
strSql.Append("Str1=SQL2012Str1,");
strSql.Append("Str2=SQL2012Str2,");
strSql.Append("Str3=SQL2012Str3,");
strSql.Append("Str4=SQL2012Str4,");
strSql.Append("Str5=SQL2012Str5,");
strSql.Append("Str6=SQL2012Str6");
strSql.Append(" where ID=SQL2012ID");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012Name", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012NormalValue", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012DepartmentID", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Price", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str1", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str2", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str3", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str4", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str5", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str6", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.NormalValue;
parameters[2].Value = model.DepartmentID;
parameters[3].Value = model.Price;
parameters[4].Value = model.Str1;
parameters[5].Value = model.Str2;
parameters[6].Value = model.Str3;
parameters[7].Value = model.Str4;
parameters[8].Value = model.Str5;
parameters[9].Value = model.Str6;
parameters[10].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DBA.Model.ExaminationItme DataRowToModel(DataRow row)
{
DBA.Model.ExaminationItme model = new DBA.Model.ExaminationItme();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["NormalValue"] != null)
{
model.NormalValue = row["NormalValue"].ToString();
}
if (row["DepartmentID"] != null)
{
model.DepartmentID = row["DepartmentID"].ToString();
}
if (row["Price"] != null)
{
model.Price = row["Price"].ToString();
}
if (row["Str1"] != null)
{
model.Str1 = row["Str1"].ToString();
}
if (row["Str2"] != null)
{
model.Str2 = row["Str2"].ToString();
}
if (row["Str3"] != null)
{
model.Str3 = row["Str3"].ToString();
}
if (row["Str4"] != null)
{
model.Str4 = row["Str4"].ToString();
}
if (row["Str5"] != null)
{
model.Str5 = row["Str5"].ToString();
}
if (row["Str6"] != null)
{
model.Str6 = row["Str6"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DBA.Model.ExaminationItme model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ExaminationItme(");
strSql.Append("Name,NormalValue,DepartmentID,Price,Str1,Str2,Str3,Str4,Str5,Str6)");
strSql.Append(" values (");
strSql.Append("SQL2012Name,SQL2012NormalValue,SQL2012DepartmentID,SQL2012Price,SQL2012Str1,SQL2012Str2,SQL2012Str3,SQL2012Str4,SQL2012Str5,SQL2012Str6)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012Name", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012NormalValue", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012DepartmentID", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Price", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str1", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str2", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str3", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str4", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str5", SqlDbType.NVarChar, 200),
new SqlParameter("SQL2012Str6", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.NormalValue;
parameters[2].Value = model.DepartmentID;
parameters[3].Value = model.Price;
parameters[4].Value = model.Str1;
parameters[5].Value = model.Str2;
parameters[6].Value = model.Str3;
parameters[7].Value = model.Str4;
parameters[8].Value = model.Str5;
parameters[9].Value = model.Str6;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DBA.Model.ExaminationItme GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,NormalValue,DepartmentID,Price,Str1,Str2,Str3,Str4,Str5,Str6 from ExaminationItme ");
strSql.Append(" where ID=SQL2012ID");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
DBA.Model.ExaminationItme model = new DBA.Model.ExaminationItme();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
