public TList <Attachment> GetAttachmentByFormID(string FormID, Pkurg.PWorld.Entities.Employee currentEmployee)
{
AttachmentService rs = new AttachmentService();
AttachmentQuery query = new AttachmentQuery();
query.Clear();
query.AppendEquals(string.Empty, AttachmentColumn.FormId, FormID);
query.AppendEquals("and", AttachmentColumn.CreateByUserCode, currentEmployee.EmployeeCode);
SqlSortBuilder <AttachmentColumn> sort = new SqlSortBuilder <AttachmentColumn>();
sort.AppendASC(AttachmentColumn.CreateAtTime);
return(rs.Find(query.GetParameters(), sort.GetSortColumns()));
}
public bool UpdateNowStatus(string wfInstanceId, string strStatus, string WorkItemCode, string WorkItemName, int WFTaskID, DateTime?FinishedTime, Pkurg.PWorld.Entities.Employee CurrentEmployee)
{
//DataProvider dataProvider = new DataProvider();
//dataProvider.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BPMConnectionString"].ConnectionString;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@UpdateByUserName", System.Data.SqlDbType.NVarChar, 100),
new SqlParameter("@wfInstanceId", System.Data.SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateByUserCode", System.Data.SqlDbType.NVarChar, 50),
new SqlParameter("@WorkItemCode", System.Data.SqlDbType.NVarChar, 100),
new SqlParameter("@WorkItemName", System.Data.SqlDbType.NVarChar, 200),
new SqlParameter("@WFTaskID", System.Data.SqlDbType.Int),
new SqlParameter("@WFStatus", System.Data.SqlDbType.NVarChar, 10)
};
parameters[0].Value = CurrentEmployee.EmployeeName;
parameters[1].Value = wfInstanceId;
parameters[2].Value = CurrentEmployee.EmployeeCode;
parameters[3].Value = WorkItemCode;
parameters[4].Value = WorkItemName;
parameters[5].Value = WFTaskID;
parameters[6].Value = strStatus;
DataTable dataTable = DBHelper.ExecutedProcedure("wf_usp_UpdateAllInfoByWfInsId", parameters);
return(true);
}
public bool UpdateStatus(string wfInstanceId, string strStatus, string WorkItemCode, string WorkItemName, int WFTaskID, DateTime?FinishedTime, Pkurg.PWorld.Entities.Employee CurrentEmployee)
{
bool result = false;
WorkFlowInstance workFlowInstance = GetWorkFlowInstanceByWFInstanceId(wfInstanceId);
workFlowInstance.SumitTime = DateTime.Now;
if (strStatus != "")
{
workFlowInstance.WfStatus = strStatus;
}
if (WorkItemCode != "")
{
workFlowInstance.WorkItemCode = WorkItemCode;
}
if (WorkItemName != "")
{
workFlowInstance.WorkItemName = WorkItemName;
}
if (WFTaskID > 0)
{
workFlowInstance.WfTaskId = WFTaskID;
}
if (FinishedTime != null)
{
workFlowInstance.FinishedTime = FinishedTime;
}
workFlowInstance.UpdateAtTime = DateTime.Now;
workFlowInstance.UpdateByUserCode = CurrentEmployee.EmployeeCode;
workFlowInstance.UpdateByUserName = CurrentEmployee.EmployeeName;
result = DataRepository.WorkFlowInstanceProvider.Update(workFlowInstance);
if (!result)
{
return(false);
}
else
{
return(true);
}
}
