public static bool Insert(ProductAssign model)
{
string sqlStr = "";
List <string> fileds = new List <string>();
List <string> pFileds = new List <string>();
List <SqlParameter> pms = new List <SqlParameter>();
#region 添加字段
if (model.StudentID != null)
{
fileds.Add("[StudentID]");
pFileds.Add("@StudentID");
pms.Add(new SqlParameter("StudentID", model.StudentID));
}
if (model.StudentPassportID != null)
{
fileds.Add("[StudentPassportID]");
pFileds.Add("@StudentPassportID");
pms.Add(new SqlParameter("StudentPassportID", model.StudentPassportID));
}
if (model.ProductID != null)
{
fileds.Add("[ProductID]");
pFileds.Add("@ProductID");
pms.Add(new SqlParameter("ProductID", model.ProductID));
}
if (model.AssignCount != null)
{
fileds.Add("[AssignCount]");
pFileds.Add("@AssignCount");
pms.Add(new SqlParameter("AssignCount", model.AssignCount));
}
if (model.HostID != null)
{
fileds.Add("[HostID]");
pFileds.Add("@HostID");
pms.Add(new SqlParameter("HostID", model.HostID));
}
#endregion
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO ProductAssign (");
sb.Append(string.Join(",", fileds.ToArray()));
sb.Append(") values (");
sb.Append(string.Join(",", pFileds.ToArray()));
sb.Append(")");
sqlStr = sb.ToString();
using (DbCommand cmd = db.GetSqlStringCommand(sqlStr))
{
cmd.Parameters.AddRange(pms.ToArray());
int i = db.ExecuteNonQuery(cmd);
return(i > 0);
}
}
public static List <ProductAssign> Search(string sqlStr, params SqlParameter[] parameters)
{
List <ProductAssign> list = new List <ProductAssign>();
using (DbCommand cmd = db.GetSqlStringCommand(sqlStr))
{
cmd.Parameters.AddRange(parameters);
DataSet ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0)
{
DataTable table = ds.Tables[0];
foreach (DataRow dr in table.Rows)
{
ProductAssign model = new ProductAssign(dr);
list.Add(model);
}
}
}
return(list);
}
public static bool Save(ProductAssign model)
{
string sqlStr = "select count(1) from ProductAssign where 1=1 ";
List <SqlParameter> pms = new List <SqlParameter>();
sqlStr += " and ProductAssignID=@ProductAssignID ";
pms.Add(new SqlParameter("ProductAssignID", model.ProductAssignID));
using (DbCommand cmd = db.GetSqlStringCommand(sqlStr))
{
cmd.Parameters.AddRange(pms.ToArray());
int i = (int)db.ExecuteScalar(cmd);
if (i > 0)
{
return(Update(model));
}
else
{
return(Insert(model));
}
}
}
