protected void lbtnNext_Click(object sender, EventArgs e) { BS_TEMPLATE_MAINBLL mbll = new BS_TEMPLATE_MAINBLL(); CMICT.CSP.Model.BS_TEMPLATE_MAIN model = new CMICT.CSP.Model.BS_TEMPLATE_MAIN(); string TemplateName = txtTemplateName.Value.Trim(); string TemplateDesc = txtTemplateDesc.Value.Trim(); string PageSize = txtPageSize.Value.Trim(); string TemplateStatus = (chkDisabled.Checked == true ? "禁用" : "草稿"); model.TemplateName = TemplateName; model.DiaplayType = ""; model.TemplateDesc = TemplateDesc; model.Reminder = ""; model.PageSize = Convert.ToDecimal(PageSize); model.ColumnSize = 0; model.TemplateStatus = "草稿"; model.SQL = ""; model.Created = DateTime.Now; model.Modified = DateTime.Now; model.Author = ""; model.Editor = ""; if (hidOperType.Value == "add") { if (!mbll.Add(model)) { Page.RegisterStartupScript("malert", "<script>alert('模板基本信息配置失败!');</script>"); } } else { Guid TemplateID = Guid.Parse(Page.Request.QueryString["templateID"]); CMICT.CSP.Model.BS_TEMPLATE_MAIN modele = mbll.GetModel(TemplateID); model.TemplateID = TemplateID; model.Created = modele.Created; model.SQL = modele.SQL; model.Reminder = modele.Reminder; model.DiaplayType = modele.DiaplayType; model.ColumnSize = modele.ColumnSize; model.Editor = ""; if (chkDisabled.Checked) { model.TemplateStatus = "禁用"; } else { model.TemplateStatus = hidDisabled.Value; } if (!mbll.Update(model)) { Page.RegisterStartupScript("malert", "<script>alert('模板基本信息修改失败!');</script>"); } } }
protected void lbtnNext_Click(object sender, EventArgs e) { bool result = false; Guid TemplateID = Guid.NewGuid(); try { BS_TEMPLATE_MAINBLL mbll = new BS_TEMPLATE_MAINBLL(); CMICT.CSP.Model.BS_TEMPLATE_MAIN model = new CMICT.CSP.Model.BS_TEMPLATE_MAIN(); string TemplateName = txtTemplateName.Value.Trim(); string TemplateDesc = txtTemplateDesc.Value.Trim(); string PageSize = txtPageSize.Value.Trim(); string TemplateStatus = "DRAFT"; model.TemplateName = TemplateName; model.DiaplayType = ""; model.TemplateDesc = TemplateDesc; model.BigCategory = txtCATEGORY.Text.Trim(); model.SmallCategory = txtsmallcategory.Text.Trim(); model.Unit = txtUnit.Value.Trim(); model.Reminder = ""; model.PageSize = Convert.ToDecimal(PageSize); model.ColumnSize = 0; model.TemplateStatus = TemplateStatus; model.SQL = ""; model.Created = DateTime.Now; model.Modified = DateTime.Now; model.Author = GetCurrentUserLoginId(); model.Editor = GetCurrentUserLoginId(); string ReturnTID = string.Empty; if (hidOperType.Value == "add") { ReturnTID = mbll.Add(model); if (string.IsNullOrEmpty(ReturnTID)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "malert", "alert('模板基本信息配置失败!');", true); } else { result = true; TemplateID = Guid.Parse(ReturnTID); //Page.Response.Redirect("DataSourceConfig.aspx?templateID=" + ReturnTID + "&sourceID=" + hidsourceid.Value.Trim(), true); } } else { TemplateID = Guid.Parse(Page.Request.QueryString["templateID"]); CMICT.CSP.Model.BS_TEMPLATE_MAIN modele = mbll.GetModel(TemplateID); model.TemplateID = TemplateID; model.Created = modele.Created; model.SQL = modele.SQL; model.Reminder = modele.Reminder; model.DiaplayType = modele.DiaplayType; model.ColumnSize = modele.ColumnSize; model.Editor = GetCurrentUserLoginId(); model.Author = modele.Author; if (!string.IsNullOrEmpty(hidsourceid.Value)) { model.SourceID = Guid.Parse(hidsourceid.Value.Trim()); } //if (chkDisabled.Checked) //{ // model.TemplateStatus = "DISABLE"; //} //else //{ model.TemplateStatus = "DRAFT"; //} if (!mbll.Update(model)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "malert", "alert('模板基本信息修改失败!');", true); } else { BusinessSearchComponent bsbll = new BusinessSearchComponent(); bsbll.RemoveTemplateByGuid(TemplateID.ToString()); result = true; } } } catch (Exception ee) { BaseComponent.Error(ee.Message); } if (result) { string edit = string.Empty; if (!string.IsNullOrEmpty(Page.Request.QueryString["type"])) { edit = "&type=edit"; } string bigname = ddlCATEGORY.SelectedItem.Text; string smallname = ddlsmallcategory.SelectedItem.Text; Page.Response.Redirect("DataSourceConfig.aspx?bname=" + Page.Server.UrlEncode(bigname) + "&sname=" + Page.Server.UrlEncode(smallname) + "&templateID=" + TemplateID.ToString() + "&sourceID=" + hidsourceid.Value.Trim() + edit, true); } }
//复制 protected void btncopy_Click(object sender, EventArgs e) { try { string TemplateID = hidtemplateid.Value.Trim(); string CopyNewName = hidCopyName.Value.Trim(); if (!string.IsNullOrEmpty(TemplateID) && !string.IsNullOrEmpty(CopyNewName)) { Guid temid = Guid.Parse(TemplateID); //复制templatemain表 BS_TEMPLATE_MAINBLL tmain = new BS_TEMPLATE_MAINBLL(); BS_TEMPLATE_MAIN tmodel = tmain.GetModel(temid); tmodel.TemplateName = CopyNewName; tmodel.Created = DateTime.Now; tmodel.Modified = DateTime.Now; tmodel.Author = BaseWebPart.GetCurrentUserLoginId(); tmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); tmodel.TemplateStatus = "FREE"; string newtemplateid = tmain.Add(tmodel); if (!string.IsNullOrEmpty(newtemplateid)) { DisplayConfigComponent dcc = new DisplayConfigComponent(); #region 制表 Guid newtemplateguid = Guid.Parse(newtemplateid); //复制bscompare表 DataTable dt = dcc.GetCalListByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_COMPUTEBLL cmain = new BS_COMPUTEBLL(); foreach (DataRow dr in dt.Rows) { BS_COMPUTE cmodel = cmain.GetModel(Guid.Parse(dr["id"].ToString())); if (cmodel != null) { cmodel.TemplateID = newtemplateguid; cmodel.Created = DateTime.Now; cmodel.Modified = DateTime.Now; cmodel.Author = BaseWebPart.GetCurrentUserLoginId(); cmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); cmain.Add(cmodel); } } } //复制BS_CUSTOM_QUERY表 dt = tmbll.GetBS_CUSTOM_QUERYIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_CUSTOM_QUERYBLL cbll = new BS_CUSTOM_QUERYBLL(); foreach (DataRow dr in dt.Rows) { BS_CUSTOM_QUERY cqmodel = cbll.GetModel(Guid.Parse(dr["id"].ToString())); if (cqmodel != null) { cqmodel.TemplateID = newtemplateguid; cqmodel.Created = DateTime.Now; cqmodel.Modified = DateTime.Now; cqmodel.Author = BaseWebPart.GetCurrentUserLoginId(); cqmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); cbll.Add(cqmodel); } } } //复制BS_CUSTOM_QUERY表 dt = tmbll.GetBS_DEFAULT_QUERYIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_DEFAULT_QUERYBLL dbll = new BS_DEFAULT_QUERYBLL(); foreach (DataRow dr in dt.Rows) { BS_DEFAULT_QUERY dmodel = dbll.GetModel(Guid.Parse(dr["id"].ToString())); if (dmodel != null) { dmodel.TemplateID = newtemplateguid; dmodel.Created = DateTime.Now; dmodel.Modified = DateTime.Now; dmodel.Author = BaseWebPart.GetCurrentUserLoginId(); dmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); dbll.Add(dmodel); } } } //复制BS_GROUPBY表 dt = tmbll.GetBS_GROUPBYIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_GROUPBYBLL gbll = new BS_GROUPBYBLL(); foreach (DataRow dr in dt.Rows) { BS_GROUPBY gmodel = gbll.GetModel(Guid.Parse(dr["id"].ToString())); if (gmodel != null) { gmodel.TemplateID = newtemplateguid; gmodel.Created = DateTime.Now; gmodel.Modified = DateTime.Now; gmodel.Author = BaseWebPart.GetCurrentUserLoginId(); gmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); gbll.Add(gmodel); } } } //复制BS_TEMPLATE_COLUMNS表 dt = tmbll.GetBS_TEMPLATE_COLUMNSIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_TEMPLATE_COLUMNSBLL tbll = new BS_TEMPLATE_COLUMNSBLL(); foreach (DataRow dr in dt.Rows) { BS_TEMPLATE_COLUMNS tcmodel = tbll.GetModel(Guid.Parse(dr["id"].ToString())); if (tcmodel != null) { tcmodel.TemplateID = newtemplateguid; tcmodel.Created = DateTime.Now; tcmodel.Modified = DateTime.Now; tcmodel.Author = BaseWebPart.GetCurrentUserLoginId(); tcmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); tbll.Add(tcmodel); } } } //复制BS_TEMPLATE_SORT表 dt = tmbll.GetBS_TEMPLATE_SORTIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_TEMPLATE_SORTBLL sbll = new BS_TEMPLATE_SORTBLL(); foreach (DataRow dr in dt.Rows) { BS_TEMPLATE_SORT smodel = sbll.GetModel(Guid.Parse(dr["id"].ToString())); if (smodel != null) { smodel.TemplateID = newtemplateguid; smodel.Created = DateTime.Now; smodel.Modified = DateTime.Now; smodel.Author = BaseWebPart.GetCurrentUserLoginId(); smodel.Editor = BaseWebPart.GetCurrentUserLoginId(); sbll.Add(smodel); } } } //复制BS_COMMUNICATION_MAIN表 dt = tmbll.GetBS_COMMUNICATION_MAINIDByTemplateID(temid); if (dt != null && dt.Rows.Count > 0) { BS_COMMUNICATION_MAINBLL sbll = new BS_COMMUNICATION_MAINBLL(); BS_COMMUNICATION_DETAILBLL detailbll = new BS_COMMUNICATION_DETAILBLL(); foreach (DataRow dr in dt.Rows) { Guid commid = Guid.NewGuid(); BS_COMMUNICATION_MAIN smodel = sbll.GetModel(Guid.Parse(dr["CommunicationID"].ToString())); if (smodel != null) { smodel.CommunicationID = commid; smodel.TargetTemplateID = newtemplateguid; smodel.Created = DateTime.Now; smodel.Modified = DateTime.Now; smodel.Author = BaseWebPart.GetCurrentUserLoginId(); smodel.Editor = BaseWebPart.GetCurrentUserLoginId(); sbll.Add(smodel); } DataTable dtdetail = tmbll.GetBS_COMMUNICATION_DETAILByID(Guid.Parse(dr["CommunicationID"].ToString())); if (dtdetail != null && dtdetail.Rows.Count > 0) { foreach (DataRow drd in dtdetail.Rows) { BS_COMMUNICATION_DETAIL sdmodel = detailbll.GetModel(Guid.Parse(drd["id"].ToString())); if (smodel != null) { sdmodel.ID = Guid.NewGuid(); sdmodel.CommunicationID = commid; sdmodel.Created = DateTime.Now; sdmodel.Modified = DateTime.Now; sdmodel.Author = BaseWebPart.GetCurrentUserLoginId(); sdmodel.Editor = BaseWebPart.GetCurrentUserLoginId(); detailbll.Add(sdmodel); } } } } } #endregion ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sucadd", "layer.alert('模板复制成功!',9);", true); BindTemplateList(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "erroradd", "layer.alert('模板复制失败!',8);", true); } } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "errora", "layer.alert('未获取到模板源信息,无法复制!',8);", true); } } catch (Exception ee) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "erroradd", "layer.alert('模板复制失败!',8);", true); BaseComponent.Error(ee.Message); } }