/// <summary>
///流程信息插入
/// </summary>
/// <param name="model">流程信息</param>
/// <returns>插入成功与否</returns>
public static bool InsertFlowInfo(FlowModel model, string StepNo,string StepName,string StepActor)
{
if (model == null)
return false ;
if (model.FlowNo=="")
{
return false;
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.FlowNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
succ = ApprovalFlowSetDBHelper.InsertFlowInfo(model,StepNo,StepName,StepActor);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
return false;
}
//try
//{
// StringBuilder sqlflow = new StringBuilder();
// sqlflow.AppendLine("INSERT INTO officedba.Flow");
// sqlflow.AppendLine(" (CompanyCD ");
// sqlflow.AppendLine(" ,DeptID ");
// sqlflow.AppendLine(" ,FlowNo ");
// sqlflow.AppendLine(" ,FlowName ");
// sqlflow.AppendLine(" ,BillTypeFlag ");
// sqlflow.AppendLine(" ,BillTypeCode ");
// sqlflow.AppendLine(" ,UsedStatus ");
// sqlflow.AppendLine(" ,ModifiedDate ");
// sqlflow.AppendLine(" ,ModifiedUserID) ");
// sqlflow.AppendLine("VALUES ");
// sqlflow.AppendLine(" ('"+model.CompanyCD+"', ");
// sqlflow.AppendLine(" '" + model.DeptID + "', ");
// sqlflow.AppendLine(" '" + model.FlowNo + "', ");
// sqlflow.AppendLine(" '" + model.FlowName + "', ");
// sqlflow.AppendLine(" '" + model.BillTypeFlag + "', ");
// sqlflow.AppendLine(" '" + model.BillTypeCode + "', ");
// sqlflow.AppendLine(" '" + model.UsedStatus + "' ");
// sqlflow.AppendLine(" ,getdate() ");
// sqlflow.AppendLine(" ,'" +model.ModifiedUserID+ "' ) ");
// #region 流程步骤SQL语句拼写
// string[] sql = null;
// try
// {
// #region 工艺明细添加SQL语句
// if (!string.IsNullOrEmpty(StepName))
// {
// int sql_index = 0;
// string[] Stepno = StepNo.Split(',');
// string[] Stepname = StepName.Split(',');
// string[] Stepactor = StepActor.Split(',');
// sql = new string[Stepname.Length + 1];
// if (Stepname.Length >= 1)
// {
// for (int i = 0; i < Stepname.Length; i++)
// {
// System.Text.StringBuilder cmdsql = new System.Text.StringBuilder();
// cmdsql.AppendLine(" Insert into officedba.FlowStepActor(CompanyCD,FlowNo,StepNo,StepName,Actor,ModifiedDate,ModifiedUserID )");
// cmdsql.AppendLine(" Values('" + model.CompanyCD + "','" + model.FlowNo + "'," + Stepno[i] + ",'" + Stepname[i].ToString() + "','" + Stepactor[i].ToString() + "','" + System.DateTime.Now + "','" + model.ModifiedUserID + "')");
// sql[sql_index] = cmdsql.ToString();
// sql_index++;
// }
// }
// sql[Stepname.Length] = sqlflow.ToString();
// #endregion
// if (ApprovalFlowSetDBHelper.InsertFlow(sql))
// {
// result = true;
// }
// }
// else
// {
// sql = new string[1];
// sql[0] = sqlflow.ToString();
// if (ApprovalFlowSetDBHelper.InsertFlow(sql))
// {
// result = true;
// }
// }
// return result;
// }
// catch (Exception ex)
// {
// throw ex;
// }
// #endregion
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
/// <summary>
/// 修改流程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateFlowInfo(FlowModel model)
{
//SQL拼写
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE officedba.Flow ");
sql.AppendLine("SET ");
sql.AppendLine(" DeptID = @DeptID, ");
sql.AppendLine(" FlowName = @FlowName , ");
sql.AppendLine(" BillTypeFlag = @BillTypeFlag , ");
sql.AppendLine(" BillTypeCode = @BillTypeCode , ");
sql.AppendLine(" ModifiedDate = @ModifiedDate , ");
sql.AppendLine(" ModifiedUserID = @ModifiedUserID ");
sql.AppendLine("WHERE ");
sql.AppendLine(" FlowNo =@FlowNo AND CompanyCD = @CompanyCD and UsedStatus='0' ");
//设置参数
SqlParameter[] param = new SqlParameter[8];
param[0] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
param[1] = SqlHelper.GetParameter("@DeptID", model.DeptID);
param[2] = SqlHelper.GetParameter("@FlowNo", model.FlowNo);
param[3] = SqlHelper.GetParameter("@FlowName", model.FlowName);
param[4] = SqlHelper.GetParameter("@BillTypeFlag", model.BillTypeFlag);
param[5] = SqlHelper.GetParameter("@BillTypeCode", model.BillTypeCode);
param[6] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now);
param[7] = SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID);
SqlHelper.ExecuteTransSql(sql.ToString(), param);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 修改审批流程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UpdateFlowInfo(FlowModel model, string StepNo, string StepName, string StepActor)
{
if (model == null)
return false;
if (model.FlowNo == "")
{
return false;
}
//try
//{
// ApprovalFlowSetDBHelper.DelFlow(model.CompanyCD, Convert.ToString(model.FlowNo));
// ApprovalFlowSetDBHelper.DelFlowstep(model.CompanyCD, Convert.ToString(model.FlowNo));
// return ApprovalFlowSetDBHelper.InsertFlowInfo(model, StepNo, StepName, StepActor);
//}
//catch (Exception)
//{
// return false;
//}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//登陆日志
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.FlowNo);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
ApprovalFlowSetDBHelper.DelFlow(model.CompanyCD, Convert.ToString(model.FlowNo));
ApprovalFlowSetDBHelper.DelFlowstep(model.CompanyCD, Convert.ToString(model.FlowNo));
succ = ApprovalFlowSetDBHelper.InsertFlowInfo(model, StepNo, StepName, StepActor);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
throw;
}
}
public static bool InsertFlowInfo(FlowModel model, string StepNo, string StepName, string StepActor)
{
ArrayList listADD = new ArrayList();
bool result = false;
try
{
#region 增加SQL语句
StringBuilder sqlflow = new StringBuilder();
sqlflow.AppendLine("INSERT INTO officedba.Flow");
sqlflow.AppendLine(" (CompanyCD ");
sqlflow.AppendLine(" ,DeptID ");
sqlflow.AppendLine(" ,FlowNo ");
sqlflow.AppendLine(" ,FlowName ");
sqlflow.AppendLine(" ,BillTypeFlag ");
sqlflow.AppendLine(" ,BillTypeCode ");
sqlflow.AppendLine(" ,UsedStatus ");
sqlflow.AppendLine(" ,IsMobileNotice ");
sqlflow.AppendLine(" ,ModifiedDate ");
sqlflow.AppendLine(" ,ModifiedUserID) ");
sqlflow.AppendLine("VALUES ");
sqlflow.AppendLine(" (@CompanyCD, ");
sqlflow.AppendLine(" @DeptID , ");
sqlflow.AppendLine(" @FlowNo , ");
sqlflow.AppendLine(" @FlowName , ");
sqlflow.AppendLine(" @BillTypeFlag, ");
sqlflow.AppendLine(" @BillTypeCode, ");
sqlflow.AppendLine(" @UsedStatus, ");
sqlflow.AppendLine(" @IsMobileNotice ");
sqlflow.AppendLine(" ,@ModifiedDate ");
sqlflow.AppendLine(" ,@ModifiedUserID) ");
SqlCommand comm = new SqlCommand();
comm.CommandText = sqlflow.ToString();
comm.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameter("@DeptID", model.DeptID));
comm.Parameters.Add(SqlHelper.GetParameter("@FlowNo", model.FlowNo));
comm.Parameters.Add(SqlHelper.GetParameter("@FlowName", model.FlowName));
comm.Parameters.Add(SqlHelper.GetParameter("@BillTypeFlag", model.BillTypeFlag));
comm.Parameters.Add(SqlHelper.GetParameter("@BillTypeCode", model.BillTypeCode));
comm.Parameters.Add(SqlHelper.GetParameter("@UsedStatus", model.UsedStatus));
comm.Parameters.Add(SqlHelper.GetParameter("@IsMobileNotice", model.IsMobileNotice));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comm.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
listADD.Add(comm);
#endregion
#region 流程步骤添加SQL语句
if (!String.IsNullOrEmpty(StepNo) && !String.IsNullOrEmpty(StepName) && !String.IsNullOrEmpty(StepActor))
{
string[] dStepNo = StepNo.Split(',');
string[] dStepName = StepName.Split(',');
string[] dStepActor = StepActor.Split(',');
//页面上这些字段都是必填，数组的长度必须是相同的
if (dStepNo.Length >= 1)
{
for (int i = 0; i < dStepNo.Length; i++)
{
System.Text.StringBuilder cmdsql = new System.Text.StringBuilder();
cmdsql.AppendLine("INSERT INTO officedba.FlowStepActor");
cmdsql.AppendLine(" (CompanyCD");
cmdsql.AppendLine(" ,FlowNo");
cmdsql.AppendLine(" ,StepNo");
cmdsql.AppendLine(" ,StepName");
cmdsql.AppendLine(" ,Actor");
cmdsql.AppendLine(" ,ModifiedDate");
cmdsql.AppendLine(" ,ModifiedUserID)");
cmdsql.AppendLine(" VALUES");
cmdsql.AppendLine(" (@CompanyCD");
cmdsql.AppendLine(" ,@FlowNo");
cmdsql.AppendLine(" ,@StepNo");
cmdsql.AppendLine(" ,@StepName");
cmdsql.AppendLine(" ,@Actor");
cmdsql.AppendLine(" ,@ModifiedDate");
cmdsql.AppendLine(" ,@ModifiedUserID)");
SqlCommand comms = new SqlCommand();
comms.CommandText = cmdsql.ToString();
comms.Parameters.Add(SqlHelper.GetParameter("@CompanyCD", model.CompanyCD));
comms.Parameters.Add(SqlHelper.GetParameter("@FlowNo", model.FlowNo));
if (dStepNo[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepNo[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@StepNo", dStepNo[i].ToString()));
}
}
if (dStepName[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepName[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@StepName", dStepName[i].ToString()));
}
}
if (dStepActor[i].ToString().Length > 0)
{
if (!string.IsNullOrEmpty(dStepActor[i].ToString().Trim()))
{
comms.Parameters.Add(SqlHelper.GetParameter("@Actor", dStepActor[i].ToString()));
}
}
comms.Parameters.Add(SqlHelper.GetParameter("@ModifiedDate", model.ModifiedDate));
comms.Parameters.Add(SqlHelper.GetParameter("@ModifiedUserID", model.ModifiedUserID));
listADD.Add(comms);
}
}
}
#endregion
if (SqlHelper.ExecuteTransWithArrayList(listADD))
{
result = true;
}
return result;
}
catch (Exception ex)
{
throw ex;
}
}
