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) { } }