public DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL GetModel(string whereSql) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" * "); strSql.Append(" from T_WorkFlow "); if (whereSql != "") { strSql.Append(" where " + whereSql + " "); } DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["WorkFlowID"].ToString() != "") { model.WorkFlowID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowID"].ToString()); model = GetModel(model.WorkFlowID); } } return(model); }
/// <summary> /// 添加 /// </summary> private void Add() { BLL.T_WorkFlow_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_WorkFlow_BLL(); Model.T_WorkFlow_MDL Newmodel = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL(); Newmodel = (Model.T_WorkFlow_MDL)Comm.GetValueToObject(Newmodel, this.tbl); CBLL.WorkFlowManage cbll = new DigiPower.Onlinecol.Standard.CBLL.WorkFlowManage(); cbll.Add(Newmodel); //CBLL.WorkFlowManage cbll = new DigiPower.Onlinecol.Standard.CBLL.WorkFlowManage(); //Model.T_WorkFlow_MDL model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL(); //BLL.T_WorkFlow_BLL bll = new DigiPower.Onlinecol.Standard.BLL.T_WorkFlow_BLL(); //object obj = Comm.GetValueToObject(model, this.tbl); //Model.T_WorkFlow_MDL Newmodel = (Model.T_WorkFlow_MDL)obj; //int FlowNo = bll.Add(Newmodel); ////子流程 //DataSet ds = bll.GetList("PID = '" + Newmodel.PID + "'"); //DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL ChildMode = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL(); //if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) //{ // ChildMode = bll.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["WorkFlowID"].ToString())); // //不是最后结点。自已不能指到自已 // if (ChildMode.WorkFlowID != FlowNo) // { // //更新子节点 // ChildMode.PID = FlowNo; // bll.Update(ChildMode); // } //} }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_WorkFlow("); strSql.Append("WorkFlowCode,WorkFlowName,OrderIndex,Del,PID,RoleID,UserID,UseForSuperAdmin,UseForArchive,UseForCompanyLeader,UseForCompany,UseForAll,"); strSql.Append("SubmitURL,DoResultURL,CompanyID,DescriptionToArchive,DescriptionToCompany,RightListID)"); strSql.Append(" values ("); strSql.Append("@WorkFlowCode,@WorkFlowName,@OrderIndex,@Del,@PID,@RoleID,@UserID,@UseForSuperAdmin,@UseForArchive,@UseForCompanyLeader,@UseForCompany,"); strSql.Append("@UseForAll,@SubmitURL,@DoResultURL,@CompanyID,@DescriptionToArchive,@DescriptionToCompany,@RightListID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WorkFlowCode", SqlDbType.NVarChar, 20), new SqlParameter("@WorkFlowName", SqlDbType.NVarChar, 20), new SqlParameter("@OrderIndex", SqlDbType.Int, 8), new SqlParameter("@Del", SqlDbType.Bit, 1), new SqlParameter("@PID", SqlDbType.Int, 8), new SqlParameter("@RoleID", SqlDbType.Int, 8), new SqlParameter("@UserID", SqlDbType.Int, 8), new SqlParameter("@UseForSuperAdmin", SqlDbType.Bit, 1), new SqlParameter("@UseForArchive", SqlDbType.Bit, 1), new SqlParameter("@UseForCompanyLeader", SqlDbType.Bit, 1), new SqlParameter("@UseForCompany", SqlDbType.Bit, 1), new SqlParameter("@UseForAll", SqlDbType.Bit, 1), new SqlParameter("@SubmitURL", SqlDbType.NVarChar, 250), new SqlParameter("@DoResultURL", SqlDbType.NVarChar, 250), new SqlParameter("@CompanyID", SqlDbType.Int, 8), new SqlParameter("@DescriptionToArchive", SqlDbType.NVarChar, 400), new SqlParameter("@DescriptionToCompany", SqlDbType.NVarChar, 400), new SqlParameter("@RightListID", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.WorkFlowCode; parameters[1].Value = model.WorkFlowName; parameters[2].Value = model.OrderIndex; parameters[3].Value = model.Del; parameters[4].Value = model.PID; parameters[5].Value = model.RoleID; parameters[6].Value = model.UserID; parameters[7].Value = model.UseForSuperAdmin; parameters[8].Value = model.UseForArchive; parameters[9].Value = model.UseForCompanyLeader; parameters[10].Value = model.UseForCompany; parameters[11].Value = model.UseForAll; parameters[12].Value = model.SubmitURL; parameters[13].Value = model.DoResultURL; parameters[14].Value = model.CompanyID; parameters[15].Value = model.DescriptionToArchive; parameters[16].Value = model.DescriptionToCompany; parameters[17].Value = model.RightListID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL GetModel(int WorkFlowID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 WorkFlowID,WorkFlowCode,WorkFlowName,OrderIndex,Del,PID,RoleID,UserID,UseForSuperAdmin,UseForArchive,UseForCompanyLeader,"); strSql.Append("UseForCompany,UseForAll,SubmitURL,DoResultURL,CompanyID,DescriptionToArchive,DescriptionToCompany,RightListID from T_WorkFlow "); strSql.Append(" where WorkFlowID=@WorkFlowID "); SqlParameter[] parameters = { new SqlParameter("@WorkFlowID", SqlDbType.Int, 8) }; parameters[0].Value = WorkFlowID; DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model = new DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["WorkFlowID"].ToString() != "") { model.WorkFlowID = int.Parse(ds.Tables[0].Rows[0]["WorkFlowID"].ToString()); } model.WorkFlowCode = ds.Tables[0].Rows[0]["WorkFlowCode"].ToString(); model.WorkFlowName = ds.Tables[0].Rows[0]["WorkFlowName"].ToString(); if (ds.Tables[0].Rows[0]["OrderIndex"].ToString() != "") { model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString()); } if (ds.Tables[0].Rows[0]["Del"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Del"].ToString() == "1") || (ds.Tables[0].Rows[0]["Del"].ToString().ToLower() == "true")) { model.Del = true; } else { model.Del = false; } } if (ds.Tables[0].Rows[0]["PID"].ToString() != "") { model.PID = int.Parse(ds.Tables[0].Rows[0]["PID"].ToString()); } if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "") { model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString() != "") { if ((ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForSuperAdmin"].ToString().ToLower() == "true")) { model.UseForSuperAdmin = true; } else { model.UseForSuperAdmin = false; } } if (ds.Tables[0].Rows[0]["UseForArchive"].ToString() != "") { if ((ds.Tables[0].Rows[0]["UseForArchive"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForArchive"].ToString().ToLower() == "true")) { model.UseForArchive = true; } else { model.UseForArchive = false; } } if (ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString() != "") { if ((ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForCompanyLeader"].ToString().ToLower() == "true")) { model.UseForCompanyLeader = true; } else { model.UseForCompanyLeader = false; } } if (ds.Tables[0].Rows[0]["UseForCompany"].ToString() != "") { if ((ds.Tables[0].Rows[0]["UseForCompany"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForCompany"].ToString().ToLower() == "true")) { model.UseForCompany = true; } else { model.UseForCompany = false; } } if (ds.Tables[0].Rows[0]["UseForAll"].ToString() != "") { if ((ds.Tables[0].Rows[0]["UseForAll"].ToString() == "1") || (ds.Tables[0].Rows[0]["UseForAll"].ToString().ToLower() == "true")) { model.UseForAll = true; } else { model.UseForAll = false; } } model.SubmitURL = ds.Tables[0].Rows[0]["SubmitURL"].ToString(); model.DoResultURL = ds.Tables[0].Rows[0]["DoResultURL"].ToString(); if (ds.Tables[0].Rows[0]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(ds.Tables[0].Rows[0]["CompanyID"].ToString()); } model.DescriptionToArchive = ds.Tables[0].Rows[0]["DescriptionToArchive"].ToString(); model.DescriptionToCompany = ds.Tables[0].Rows[0]["DescriptionToCompany"].ToString(); model.RightListID = ds.Tables[0].Rows[0]["RightListID"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_WorkFlow_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_WorkFlow set "); strSql.Append("WorkFlowCode=@WorkFlowCode,"); strSql.Append("WorkFlowName=@WorkFlowName,"); strSql.Append("OrderIndex=@OrderIndex,"); strSql.Append("Del=@Del,"); strSql.Append("PID=@PID,"); strSql.Append("RoleID=@RoleID,"); strSql.Append("UserID=@UserID,"); strSql.Append("UseForSuperAdmin=@UseForSuperAdmin,"); strSql.Append("UseForArchive=@UseForArchive,"); strSql.Append("UseForCompanyLeader=@UseForCompanyLeader,"); strSql.Append("UseForCompany=@UseForCompany,"); strSql.Append("UseForAll=@UseForAll,"); strSql.Append("SubmitURL=@SubmitURL,"); strSql.Append("DoResultURL=@DoResultURL,"); strSql.Append("CompanyID=@CompanyID,"); strSql.Append("DescriptionToArchive=@DescriptionToArchive,"); strSql.Append("DescriptionToCompany=@DescriptionToCompany,"); strSql.Append("RightListID=@RightListID"); strSql.Append(" where WorkFlowID=@WorkFlowID "); SqlParameter[] parameters = { new SqlParameter("@WorkFlowID", SqlDbType.Int, 8), new SqlParameter("@WorkFlowCode", SqlDbType.NVarChar, 20), new SqlParameter("@WorkFlowName", SqlDbType.NVarChar, 20), new SqlParameter("@OrderIndex", SqlDbType.Int, 8), new SqlParameter("@Del", SqlDbType.Bit, 1), new SqlParameter("@PID", SqlDbType.Int, 8), new SqlParameter("@RoleID", SqlDbType.Int, 8), new SqlParameter("@UserID", SqlDbType.Int, 8), new SqlParameter("@UseForSuperAdmin", SqlDbType.Bit, 1), new SqlParameter("@UseForArchive", SqlDbType.Bit, 1), new SqlParameter("@UseForCompanyLeader", SqlDbType.Bit, 1), new SqlParameter("@UseForCompany", SqlDbType.Bit, 1), new SqlParameter("@UseForAll", SqlDbType.Bit, 1), new SqlParameter("@SubmitURL", SqlDbType.NVarChar, 250), new SqlParameter("@DoResultURL", SqlDbType.NVarChar, 250), new SqlParameter("@CompanyID", SqlDbType.Int, 8), new SqlParameter("@DescriptionToArchive", SqlDbType.NVarChar, 400), new SqlParameter("@DescriptionToCompany", SqlDbType.NVarChar, 400), new SqlParameter("@RightListID", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.WorkFlowID; parameters[1].Value = model.WorkFlowCode; parameters[2].Value = model.WorkFlowName; parameters[3].Value = model.OrderIndex; parameters[4].Value = model.Del; parameters[5].Value = model.PID; parameters[6].Value = model.RoleID; parameters[7].Value = model.UserID; parameters[8].Value = model.UseForSuperAdmin; parameters[9].Value = model.UseForArchive; parameters[10].Value = model.UseForCompanyLeader; parameters[11].Value = model.UseForCompany; parameters[12].Value = model.UseForAll; parameters[13].Value = model.SubmitURL; parameters[14].Value = model.DoResultURL; parameters[15].Value = model.CompanyID; parameters[16].Value = model.DescriptionToArchive; parameters[17].Value = model.DescriptionToCompany; parameters[18].Value = model.RightListID; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }