public static DrugProjectItem GetDrugProjectItem(string ID)
{
DrugProjectItem product = Db.Sql(@"select * from DrugProjectItem where ID = @0").Parameters(ID)
.QuerySingle <DrugProjectItem>();
return(product);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public static void AddProjectItem(DrugProjectItem model)
{
model.ID = CurrentID("DrugProjectItem");
int row = Db.Sql(@"insert into DrugProjectItem values(@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13);")
.Parameters(
model.ID,
model.DrugProjectID,
model.CodeNum1,
model.CodeNum2,
model.PJSFMJ,
model.GSCYL,
model.XSBS,
model.DZLD,
model.DZFMJ,
model.HL,
model.PJHL,
model.FC,
model.IsFuCe,
model.type
).Execute();
//记录日志
model = GetProjectItem(model.ID);
LogProjectItem(model.ID, ProjectLogType.添加, null, model);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public static void UpdateProjectItem(DrugProjectItem model, bool islog = false)
{
DrugProjectItem product = GetProjectItem(model.ID);
//记录日志
if (islog)
{
LogProjectItem(product.DrugProjectID, ProjectLogType.修改, product, model);
}
product.DZFMJ = model.DZFMJ;
product.DZLD = model.DZLD;
product.FC = model.FC;
product.GSCYL = model.GSCYL;
product.HL = model.HL;
product.PJHL = model.PJHL;
product.PJSFMJ = model.PJSFMJ;
product.XSBS = model.XSBS;
try
{
int rowsAffected = Db.Update("DrugProjectItem")
.Column("DZFMJ", product.DZFMJ)
.Column("DZLD", product.DZLD)
.Column("FC", product.FC)
.Column("GSCYL", product.GSCYL)
.Column("HL", product.HL)
.Column("PJHL", product.PJHL)
.Column("PJSFMJ", product.PJSFMJ)
.Column("XSBS", product.XSBS)
.Where("ID", product.ID)
.Execute();
}
catch (Exception ex)
{
}
}
