/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model)
{
BLL.T_WorkFlow_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_WorkFlow_BLL();
Model.T_WorkFlow_MDL currentMDL = bll.GetModel(model.WorkFlowID);
//原 父 ,可空
Model.T_WorkFlow_MDL oldParentMDL = bll.GetModel("WorkFlowID=" + currentMDL.PID);
//原 子 ,可空
Model.T_WorkFlow_MDL oldChildMDL = bll.GetModel("PID=" + currentMDL.WorkFlowID);
//新 父 ,可空
Model.T_WorkFlow_MDL newParentMDL = bll.GetModel("WorkFlowID=" + model.PID);
//新 子 ,新父的子,可空
Model.T_WorkFlow_MDL newChildMDL = null;
if (newParentMDL != null)
{
newChildMDL = bll.GetModel("PID=" + newParentMDL.WorkFlowID);
}
else if (model.PID == 0)
{
newChildMDL = bll.GetModel("PID=" + model.PID);
}
bll.Update(model); //更新填的结果
if (oldChildMDL != null) // && newChildMDL.WorkFlowID > 0
{
if (oldParentMDL != null)
{
oldChildMDL.PID = oldParentMDL.WorkFlowID;
}
else
{
oldChildMDL.PID = 0;
}
bll.Update(oldChildMDL);
}
if (newChildMDL != null)// && newChildMDL.WorkFlowID > 0
{
newChildMDL.PID = model.WorkFlowID;
bll.Update(newChildMDL);
}
}
public int Add(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model)
{
int WorkFlowID = 0;
BLL.T_WorkFlow_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_WorkFlow_BLL();
if (model.PID == 0)
{
Model.T_WorkFlow_MDL newChildMDL = bll.GetModel("PID=" + model.PID);
WorkFlowID = bll.Add(model);
newChildMDL.PID = WorkFlowID;
bll.Update(newChildMDL);
}
else
{
//新 父
Model.T_WorkFlow_MDL newParentMDL = bll.GetModel("WorkFlowID=" + model.PID);
//新 子
Model.T_WorkFlow_MDL newChildMDL = bll.GetModel("PID=" + newParentMDL.WorkFlowID);
WorkFlowID = bll.Add(model);//更新填的结果
//更新父子关系
Model.T_WorkFlow_MDL parentMDL = bll.GetModel("WorkFlowID=" + model.PID);
if (newParentMDL != null)
{
if (newChildMDL != null)
{
newChildMDL.PID = WorkFlowID;
bll.Update(newChildMDL);
}
}
WorkFlowID = model.WorkFlowID;
}
return(WorkFlowID);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model)
{
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL> DataTableToList(DataTable dt)
{
List <DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL> modelList = new List <DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model;
for (int n = 0; n < rowsCount; n++)
{
model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL();
if (dt.Rows[n]["WorkFlowID"].ToString() != "")
{
model.WorkFlowID = int.Parse(dt.Rows[n]["WorkFlowID"].ToString());
}
model.WorkFlowCode = dt.Rows[n]["WorkFlowCode"].ToString();
model.WorkFlowName = dt.Rows[n]["WorkFlowName"].ToString();
if (dt.Rows[n]["OrderIndex"].ToString() != "")
{
model.OrderIndex = int.Parse(dt.Rows[n]["OrderIndex"].ToString());
}
if (dt.Rows[n]["Del"].ToString() != "")
{
if ((dt.Rows[n]["Del"].ToString() == "1") || (dt.Rows[n]["Del"].ToString().ToLower() == "true"))
{
model.Del = true;
}
else
{
model.Del = false;
}
}
if (dt.Rows[n]["PID"].ToString() != "")
{
model.PID = int.Parse(dt.Rows[n]["PID"].ToString());
}
if (dt.Rows[n]["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(dt.Rows[n]["RoleID"].ToString());
}
if (dt.Rows[n]["UserID"].ToString() != "")
{
model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString());
}
if (dt.Rows[n]["UseForSuperAdmin"].ToString() != "")
{
if ((dt.Rows[n]["UseForSuperAdmin"].ToString() == "1") || (dt.Rows[n]["UseForSuperAdmin"].ToString().ToLower() == "true"))
{
model.UseForSuperAdmin = true;
}
else
{
model.UseForSuperAdmin = false;
}
}
if (dt.Rows[n]["UseForArchive"].ToString() != "")
{
if ((dt.Rows[n]["UseForArchive"].ToString() == "1") || (dt.Rows[n]["UseForArchive"].ToString().ToLower() == "true"))
{
model.UseForArchive = true;
}
else
{
model.UseForArchive = false;
}
}
if (dt.Rows[n]["UseForCompanyLeader"].ToString() != "")
{
if ((dt.Rows[n]["UseForCompanyLeader"].ToString() == "1") || (dt.Rows[n]["UseForCompanyLeader"].ToString().ToLower() == "true"))
{
model.UseForCompanyLeader = true;
}
else
{
model.UseForCompanyLeader = false;
}
}
if (dt.Rows[n]["UseForCompany"].ToString() != "")
{
if ((dt.Rows[n]["UseForCompany"].ToString() == "1") || (dt.Rows[n]["UseForCompany"].ToString().ToLower() == "true"))
{
model.UseForCompany = true;
}
else
{
model.UseForCompany = false;
}
}
if (dt.Rows[n]["UseForAll"].ToString() != "")
{
if ((dt.Rows[n]["UseForAll"].ToString() == "1") || (dt.Rows[n]["UseForAll"].ToString().ToLower() == "true"))
{
model.UseForAll = true;
}
else
{
model.UseForAll = false;
}
}
model.SubmitURL = dt.Rows[n]["SubmitURL"].ToString();
model.DoResultURL = dt.Rows[n]["DoResultURL"].ToString();
if (dt.Rows[n]["CompanyID"].ToString() != "")
{
model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString());
}
model.DescriptionToArchive = dt.Rows[n]["DescriptionToArchive"].ToString();
model.DescriptionToCompany = dt.Rows[n]["DescriptionToCompany"].ToString();
model.RightListID = dt.Rows[n]["RightListID"].ToString();
modelList.Add(model);
}
}
return(modelList);
}