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