public void pubUserResource(FBForm model, List <FBFormLink> linkList) { try { Db.BeginTransaction(); model.LastModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.LastModifyUser = SessionProvider.Provider.Current().UserName; Sql sql = new Sql(@" update FBForm set CSSInfo=@0,UserJS=@1,LastModifyTime=@2, LastModifyUser=@3 where ID=@4", model.CSSInfo, model.UserJS, model.LastModifyTime, model.LastModifyUser, model.ID); base.Db.Execute(sql); base.Db.Execute(new Sql("delete from FBFormLink where formID=@0", model.ID)); var i = 0; foreach (var item in linkList) { item.Ord = i.ToString(); i += 5; // 循环保存引用 Db.Save <FBFormLink>(item); } Db.CompleteTransaction(); } catch (Exception ex) { Db.AbortTransaction(); throw ex; } }
public RepoResult LockData() { SqlParameter outputRetVal = CreateSqlParameterOutputReturnValue("RetVal"); SqlParameter outputErrMesg = CreateSqlParameterOutputErrMesg("ErrMesg"); dynamic args = new { RetVal = outputRetVal, ErrMesg = outputErrMesg, DataId = DATA_ID, ModuleId = MODULE_ID, FunctionId = FUNCTION_ID, UserId = LOCKED_BY, ActionType = ACTION_TYPE }; RepoResult repoResult = new RepoResult(); try { Db.BeginTransaction(); int result = Db.Execute("Shared/LockData", args); repoResult.Result = RepoResult.VALUE_SUCCESS; if ((int)outputRetVal.Value != 0) { repoResult.Result = RepoResult.VALUE_ERROR; string errMesg = string.Empty; if (outputErrMesg != null && outputErrMesg.Value != null) { errMesg = outputErrMesg.Value.ToString(); } repoResult.ErrMesgs = new string[1]; repoResult.ErrMesgs[0] = errMesg; Db.AbortTransaction(); } else { Db.CommitTransaction(); } } catch (Exception e) { repoResult.Result = RepoResult.VALUE_ERROR; repoResult.ErrMesgs = new string[1]; repoResult.ErrMesgs[0] = e.Message; Db.AbortTransaction(); } return(repoResult); }
public RepoResult Insert(string userId, Approval app) { SqlParameter outputRetVal = CreateSqlParameterOutputReturnValue("RetVal"); SqlParameter outputErrMesg = CreateSqlParameterOutputErrMesg("ErrMesg"); SqlParameter outputTblApprovalFlow = CreateSqlParameterOutputTblOfApprovalFlow("TableOfVarPo", app.listApprovalFlow, "dbo.TableOfVarPo"); dynamic args = new { RetVal = outputRetVal, ErrMesg = outputErrMesg, UserId = userId, Po = app.po_no, Pr = app.pr_no, PoDate = app.po_date, Supplier = app.supplier_code, TableApprovalFlow = outputTblApprovalFlow }; Db.BeginTransaction(); int result = Db.Execute("Po/Po_Insert", args); RepoResult repoResult = new RepoResult(); repoResult.Result = RepoResult.VALUE_SUCCESS; if ((int)outputRetVal.Value != 0) { repoResult.Result = RepoResult.VALUE_ERROR; string errMesg = string.Empty; if (outputErrMesg != null && outputErrMesg.Value != null) { errMesg = outputErrMesg.Value.ToString(); } repoResult.ErrMesgs = new string[1]; repoResult.ErrMesgs[0] = errMesg; Db.AbortTransaction(); } else { Db.CommitTransaction(); } return(repoResult); }
public RepoResult InsertAttachment(string id, string tempFilePath, string tempFileName) { SqlParameter outputRetVal = CreateSqlParameterOutputReturnValue("RetVal"); SqlParameter outputErrMesg = CreateSqlParameterOutputErrMesg("ErrMesg"); dynamic args = new { RetVal = outputRetVal, ErrMesg = outputErrMesg, Id = id, TempFilePath = tempFilePath, TempFileName = tempFileName }; Db.BeginTransaction(); int result = Db.Execute("FileTemp/FileTemp_Insert", args); RepoResult repoResult = new RepoResult(); repoResult.Result = RepoResult.VALUE_SUCCESS; if ((int)outputRetVal.Value != 0) { repoResult.Result = RepoResult.VALUE_ERROR; string errMesg = string.Empty; if (outputErrMesg != null && outputErrMesg.Value != null) { errMesg = outputErrMesg.Value.ToString(); } repoResult.ErrMesgs = new string[1]; repoResult.ErrMesgs[0] = errMesg; Db.AbortTransaction(); } else { Db.CommitTransaction(); } return(repoResult); }
public RepoResult DeleteAttachment(string fileName) { fileName = Regex.Replace(fileName, @"\\\\Photo\\\\", ""); SqlParameter outputRetVal = CreateSqlParameterOutputReturnValue("RetVal"); SqlParameter outputErrMesg = CreateSqlParameterOutputErrMesg("ErrMesg"); dynamic args = new { RetVal = outputRetVal, ErrMesg = outputErrMesg, TempFileName = fileName }; Db.BeginTransaction(); int result = Db.Execute("FileTemp/FileTemp_Delete", args); RepoResult repoResult = new RepoResult(); repoResult.Result = RepoResult.VALUE_SUCCESS; if ((int)outputRetVal.Value != 0) { repoResult.Result = RepoResult.VALUE_ERROR; string errMesg = string.Empty; if (outputErrMesg != null && outputErrMesg.Value != null) { errMesg = outputErrMesg.Value.ToString(); } repoResult.ErrMesgs = new string[1]; repoResult.ErrMesgs[0] = errMesg; Db.AbortTransaction(); } else { Db.CommitTransaction(); } return(repoResult); }