Exemplo n.º 1
0
        //保存
        protected void lbtnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (!string.IsNullOrEmpty(hidTemplateID.Value))
                {
                    bool adduserquery    = false;
                    bool adddefaultquery = false;
                    //bool iddel = true;
                    if (hidopertype.Value == "edit")//如果是更新,先删除之前的配置信息
                    {
                        bll.DeleteTemInfoByTemplateID(hidTemplateID.Value);
                    }
                    string DefaultQueryContent = hidDefaultContent.Value.TrimEnd(';');//用户默认筛选条件内容
                    if (!string.IsNullOrEmpty(DefaultQueryContent))
                    {
                        string MainLogic = "";
                        if (radand.Checked)
                        {
                            MainLogic = "and";
                        }
                        if (rador.Checked)
                        {
                            MainLogic = "or";
                        }
                        BS_DEFAULT_QUERYBLL qcqbll = new BS_DEFAULT_QUERYBLL();
                        string[]            uqlist = DefaultQueryContent.Split(';');
                        double addm = 10;
                        foreach (string uqinfo in uqlist)
                        {
                            addm++;
                            string[]         uqinfolist = uqinfo.Split('|');
                            BS_DEFAULT_QUERY model      = new BS_DEFAULT_QUERY();
                            model.TemplateID   = Guid.Parse(hidTemplateID.Value);
                            model.ColumnName   = uqinfolist[0];
                            model.MainLogic    = MainLogic;
                            model.Compare      = uqinfolist[1];
                            model.CompareValue = uqinfolist[2];
                            model.Desction     = uqinfolist[3];
                            model.ModuleID     = Convert.ToInt32(uqinfolist[4]);
                            model.SubLogic     = uqinfolist[5];

                            model.Created   = DateTime.Now.AddMilliseconds(addm);
                            model.Modified  = DateTime.Now;
                            model.Author    = BaseWebPart.GetCurrentUserLoginId();
                            model.Editor    = BaseWebPart.GetCurrentUserLoginId();
                            adddefaultquery = qcqbll.Add(model);
                        }
                    }
                    string UserQueryContent = hidUserQueryContent.Value.TrimEnd('$');//用户筛选配置内容
                    if (!string.IsNullOrEmpty(UserQueryContent))
                    {
                        BS_CUSTOM_QUERYBLL qcqbll = new BS_CUSTOM_QUERYBLL();
                        string[]           uqlist = UserQueryContent.Split('$');
                        double             addm   = 10;
                        foreach (string uqinfo in uqlist)
                        {
                            addm++;
                            string[]        uqinfolist = uqinfo.Split('|');
                            BS_CUSTOM_QUERY model      = new BS_CUSTOM_QUERY();
                            model.TemplateID  = Guid.Parse(hidTemplateID.Value);
                            model.ColumnName  = uqinfolist[0];
                            model.DisplayName = uqinfolist[1];
                            model.ControlType = uqinfolist[2];
                            model.Compare     = uqinfolist[3];
                            model.Sequence    = -1;
                            if (!string.IsNullOrEmpty(uqinfolist[4]))
                            {
                                model.Sequence = decimal.Parse(uqinfolist[4]);
                            }
                            model.DefaultValue = uqinfolist[6];
                            model.Reminder     = uqinfolist[5];
                            model.Created      = DateTime.Now.AddMilliseconds(addm);
                            model.Modified     = DateTime.Now;
                            model.Author       = BaseWebPart.GetCurrentUserLoginId();
                            model.Editor       = BaseWebPart.GetCurrentUserLoginId();
                            adduserquery       = qcqbll.Add(model);
                        }
                    }
                    string edit = string.Empty;
                    if (!string.IsNullOrEmpty(Page.Request.QueryString["type"]))
                    {
                        edit = "&type=edit";
                    }
                    BusinessSearchComponent bsbll = new BusinessSearchComponent();
                    bsbll.RemoveTemplateByGuid(hidTemplateID.Value);
                    string sourceid = hidsourceid.Value.Trim();
                    if (adduserquery || adddefaultquery)
                    {
                        ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "subsuc", "layer.alert('用户筛选条件配置成功!');", true);
                        Page.Response.Redirect("CommunicationConfig.aspx?templateID=" + hidTemplateID.Value + "&sourceID=" + sourceid + edit);
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "subsucerror", "layer.alert('用户筛选条件配置失败!');", true);
                    }
                    if (string.IsNullOrEmpty(DefaultQueryContent) && string.IsNullOrEmpty(UserQueryContent))
                    {
                        Page.Response.Redirect("CommunicationConfig.aspx?templateID=" + hidTemplateID.Value + "&sourceID=" + sourceid + edit);
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "suberror", "layer.alert('未获取到模板编号!');", true);
                }
            }
            catch (Exception ee)
            {
                BaseComponent.Error(ee.Message);
            }
        }
Exemplo n.º 2
0
        //复制
        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);
            }
        }