private void BindCommunication(string id) { if (string.IsNullOrEmpty(id)) { ddlCommunicationID.DataSource = null; ddlCommunicationID.Items.Clear(); ddlCommunicationID.DataBind(); return; } CommunicationConfigComponent commuCom = new CommunicationConfigComponent(); DataTable communication = commuCom.GetCommunicationByTemplateID(id); if (communication == null || communication.Rows.Count == 0) { ddlCommunicationID.DataSource = null; ddlCommunicationID.Items.Clear(); ddlCommunicationID.DataBind(); return; } ddlCommunicationID.DataSource = communication; ddlCommunicationID.DataTextField = "Name"; ddlCommunicationID.DataValueField = "CommunicationID"; ddlCommunicationID.DataBind(); }
protected void btnEdit_Click(object sender, EventArgs e) { try { trbig.Attributes.Add("style", "display:none;"); trsmall.Attributes.Add("style", "display:none;"); BindSourceTemplate("", ""); string communicationID = hidCommunicationID.Value; if (communicationID.Length <= 0) { return; } DataTable dtCommu = dc.GetCommunicationConfigInfoByID(communicationID); string sourceTemplateID = ""; if (dtCommu != null && dtCommu.Rows.Count > 0) { sourceTemplateID = Convert.ToString(dtCommu.Rows[0]["SourceTemplateID"]); txtName.Value = Convert.ToString(dtCommu.Rows[0]["Name"]); } if (!string.IsNullOrEmpty(sourceTemplateID)) { ddlSourceTemplate.Items.FindByValue(sourceTemplateID).Selected = true; txtSourceTemplate.Text = sourceTemplateID; CMICT.CSP.Model.BS_DATASOURCE model = bll.GetModel(sourceTemplateID); if (model != null) { CommunicationConfigComponent dcserver = new CommunicationConfigComponent(model.SourceIP, model.UserName, model.Password, model.DBName); DataTable dtSourceColumns = dcserver.GetSourceDataColumnBytemID(sourceTemplateID, model.ObjectType, model.ObjectName); if (dtSourceColumns != null && dtSourceColumns.Rows.Count > 0) { foreach (DataRow dr in dtSourceColumns.Rows) { dr["TargetColumnName"] = dc.GetTargetColumnNameByColNameAndComid(dr["ColumnName"].ToString(), communicationID); } } //DataTable dtSourceColumns = dc.GetCommunicationDetailByID(communicationID); CommunicationDetailList.DataSource = dtSourceColumns; CommunicationDetailList.DataBind(); if (dtSourceColumns != null) { txtSelected.Text = dtSourceColumns.Rows.Count.ToString(); } } } ddlSourceTemplate.Enabled = false; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "showDetail", "showDetail();", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alertException", "javascript:showMessage('操作发生错误:" + ex.Message.Replace("'", "").Replace("\"", "") + "!',8);", true); } }
//删除 protected void lbtndel_Click(object sender, EventArgs e) { try { string TemplateID = hidtemplateid.Value.Trim(); string SourceID = hidsourceid.Value.Trim(); if (!string.IsNullOrEmpty(TemplateID)) { //删除通信配置 CommunicationConfigComponent cccbll = new CommunicationConfigComponent(); cccbll.DeleteCommunicationByTemplateID(TemplateID); if (tmbll.DelTemplateInfo(TemplateID)) { hidtemplateid.Value = ""; if (!string.IsNullOrEmpty(SourceID)) { //删除后查询原数据源是否还有被其它模板引用,没有则更新状态为空闲 ConnectionConfigComponent ccc = new ConnectionConfigComponent(); DataTable dstable = ccc.GetTemplateIDBySourceID(Guid.Parse(SourceID)); if (dstable == null || dstable.Rows.Count == 0) { DataSourceConfigComponent dbll = new DataSourceConfigComponent(); dbll.UpdateSourceStatusBySourceID(hidsourceid.Value.Trim()); } } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sdel", "layer.alert('模板删除成功!',9);", true); BindTemplateList(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sdel", "layer.alert('模板删除失败!',8);", true); } } } catch (Exception ee) { BaseComponent.Error(ee.Message); } }
protected void ddlSourceTemplate_SelectedIndexChanged(object sender, EventArgs e) { try { string sourceTemplateID = ddlSourceTemplate.SelectedValue; if (!string.IsNullOrEmpty(sourceTemplateID)) { CMICT.CSP.Model.BS_DATASOURCE model = bll.GetModel(sourceTemplateID); if (model != null) { CommunicationConfigComponent dcserver = new CommunicationConfigComponent(model.SourceIP, model.UserName, model.Password, model.DBName); DataTable dtCommu = dcserver.GetSourceDataColumnBytemID(sourceTemplateID, model.ObjectType, model.ObjectName); CommunicationDetailList.DataSource = dtCommu; CommunicationDetailList.DataBind(); } } ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "showDetail", "showDetail();", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alertException", "javascript:showMessage('操作发生错误:" + ex.Message.Replace("'", "").Replace("\"", "") + "!',8);", true); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string edit = string.Empty; if (!string.IsNullOrEmpty(Page.Request.QueryString["type"])) { hidisedit.Value = "edit"; } if (!string.IsNullOrEmpty(Page.Request.QueryString["sourceID"])) { try { hidsourceid.Value = Page.Request.QueryString["sourceID"]; CMICT.CSP.Model.BS_DATASOURCE model = bll.GetModel(Guid.Parse(hidsourceid.Value)); if (model != null) { BindBigCategory(); CommunicationConfigComponent dcserver = new CommunicationConfigComponent(model.SourceIP, model.UserName, model.Password, model.DBName); if (!string.IsNullOrEmpty(Page.Request.QueryString["templateID"])) { hidTemplateID.Value = Page.Request.QueryString["templateID"]; BindCommunicationData(); DataTable dtTargetColumns = dcserver.GetSourceDataColumnBytemID(hidTemplateID.Value, model.ObjectType, model.ObjectName); //DataTable dtTargetColumns = dc.GetDataColumnByTemplateID(hidTemplateID.Value); ViewState["TargetColumns"] = dtTargetColumns; } } } catch (Exception ex) { BaseComponent.Error("CommunicationConfig-页面加载出错:" + ex.Message); } } } }
protected void lbtnSave_Click(object sender, EventArgs e) { string edit = string.Empty; if (!string.IsNullOrEmpty(Page.Request.QueryString["type"])) { edit = "&type=edit"; } try { string TemplateID = Page.Request.QueryString["templateID"]; string SourceID = ddlSourceName.SelectedValue; if (hidsourceid.Value.Trim() != SourceID.Trim())//修改数据源后删除显示与查询配置信息 { if (!string.IsNullOrEmpty(TemplateID)) { if (dbll.OperConfigDataSource(TemplateID, SourceID)) { if (!string.IsNullOrEmpty(hidsourceid.Value.Trim())) { //更新后查询原数据源是否还有被其它模板引用,没有则更新状态为草稿 ConnectionConfigComponent ccc = new ConnectionConfigComponent(); DataTable dstable = ccc.GetTemplateIDBySourceID(Guid.Parse(hidsourceid.Value.Trim())); if (dstable == null || dstable.Rows.Count == 0) { dbll.UpdateSourceStatusBySourceID(hidsourceid.Value.Trim()); } } DisplayConfigComponent dcbll = new DisplayConfigComponent(); dcbll.DeleteTemInfoByTemplateID(TemplateID); dcbll.UpdateStatusByTemplateID(TemplateID, "DRAFT"); QueryConfigComponent qcbll = new QueryConfigComponent(); qcbll.DeleteTemInfoByTemplateID(TemplateID); CommunicationConfigComponent cccbll = new CommunicationConfigComponent(); //取出所有与此模板有通信关联的源模板信息 DataTable SourceTemList = cccbll.GetCommunicationBySourceTemplateID(TemplateID); //删除通信配置 cccbll.DeleteCommunicationByTemplateID(TemplateID); //刷新模板缓存 BusinessSearchComponent bsbll = new BusinessSearchComponent(); //bsbll.RefreshTemplateByGuid(TemplateID); bsbll.RemoveTemplateByGuid(TemplateID); if (SourceTemList != null && SourceTemList.Rows.Count > 0) { foreach (DataRow dr in SourceTemList.Rows) { if (!string.IsNullOrEmpty(Convert.ToString(dr["TargetTemplateID"]))) { bsbll.RemoveTemplateByGuid(Convert.ToString(dr["TargetTemplateID"])); } } } Page.Response.Redirect("DisplayConfig.aspx?templateID=" + TemplateID + "&sourceID=" + SourceID + edit + ""); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sourceerror", "layer.alert('数据源配置失败!',8);", true); } } } else { Page.Response.Redirect("DisplayConfig.aspx?templateID=" + TemplateID + "&sourceID=" + SourceID + edit + ""); } } catch (Exception ex) { BaseComponent.Error("DataSourceConfig-lbtnSave_Click:" + ex.Message); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sourceerrorex", "layer.alert('数据源配置失败!',8);", true); } }
protected void lbtnSave_Click(object sender, EventArgs e) { try { string tipcontent = string.Empty; if (!TestConn(out tipcontent))//如果连接失败 { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "saveconntest", "layer.alert('连接测试失败" + tipcontent + "!',8);executeconnectsur();", true); return; } string SourceName = this.txtSourceName.Value.Trim(); string SourceDesc = this.txtSourceDesc.Value.Trim(); string SourceIP = this.txtSourceIP.Value.Trim(); string UserName = this.txtUserName.Value.Trim(); string Password = this.txtPwd.Text.Trim(); string DBName = this.txtDBName.Text.Trim(); string ObjectType = this.txtObjectType.Text.Trim(); string ObjectName = this.txtObjectName.Text.Trim(); string SourceStatus = "FREE"; DateTime Created = DateTime.Now; DateTime Modified = DateTime.Now; string Author = GetCurrentUserLoginId(); string Editor = GetCurrentUserLoginId(); CMICT.CSP.BLL.BS_DATASOURCEBLL bll = new CMICT.CSP.BLL.BS_DATASOURCEBLL(); string rsourceid = string.Empty; if (hidOperType.Value == "edit") { rsourceid = Page.Request.QueryString["sourceID"]; } if (bll.GetExists(SourceName, rsourceid)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "sourcenameexist", "layer.alert('已经存在此数据源名称:" + SourceName + "!请重新填写!',8);executeconnectsur();", true); return; } CMICT.CSP.Model.BS_DATASOURCE model = new CMICT.CSP.Model.BS_DATASOURCE(); model.SourceName = SourceName; model.SourceDesc = SourceDesc; model.SourceIP = SourceIP; model.UserName = UserName; model.Password = Password; model.DBName = DBName; model.ObjectType = ObjectType; model.ObjectName = ObjectName; model.SourceStatus = SourceStatus; model.Created = Created; model.Modified = Modified; model.Author = Author; model.Editor = Editor; model.BigCategory = txtCATEGORY.Text; model.SmallCategory = txtsmallcategory.Text; model.SourceCNName = ""; if (hidOperType.Value == "add") { if (bll.Add(model)) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connsuca", "layer.alert('数据源新增成功!',9);", true); Page.Response.Redirect("DataSourceManage.aspx"); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connerrora", "layer.alert('数据源新增失败!',8);", true); } } else//修改 { Guid SourceID = Guid.Parse(Page.Request.QueryString["sourceID"]); CMICT.CSP.Model.BS_DATASOURCE oldmodel = bll.GetModel(SourceID); model.SourceID = SourceID; model.Author = hidauthor.Value; model.Created = DateTime.Parse(hidcreated.Value); model.SourceStatus = hidSourceStatus.Value.Trim(); if (bll.Update(model)) { //更新数据源后清空相应模板的配置信息 if (model.DBName != oldmodel.DBName || model.SourceIP != oldmodel.SourceIP || model.UserName != oldmodel.UserName || model.Password != oldmodel.Password || model.ObjectType != oldmodel.ObjectType || model.ObjectName != oldmodel.ObjectName) { ConnectionConfigComponent ccc = new ConnectionConfigComponent(); DataTable dstable = ccc.GetTemplateIDBySourceID(SourceID); if (dstable != null && dstable.Rows.Count > 0) { DisplayConfigComponent dcbll = new DisplayConfigComponent(); QueryConfigComponent qcbll = new QueryConfigComponent(); BusinessSearchComponent bsbll = new BusinessSearchComponent(); //删除通信配置 CommunicationConfigComponent cccbll = new CommunicationConfigComponent(); foreach (DataRow dr in dstable.Rows) { dcbll.UpdateStatusByTemplateID(dr["TemplateID"].ToString(), "DRAFT"); dcbll.DeleteTemInfoByTemplateID(dr["TemplateID"].ToString()); qcbll.DeleteTemInfoByTemplateID(dr["TemplateID"].ToString()); //取出所有与此模板有通信关联的源模板信息 DataTable SourceTemList = cccbll.GetCommunicationBySourceTemplateID(dr["TemplateID"].ToString()); cccbll.DeleteCommunicationByTemplateID(dr["TemplateID"].ToString()); bsbll.RefreshTemplateByGuid(dr["TemplateID"].ToString()); if (SourceTemList != null && SourceTemList.Rows.Count > 0) { foreach (DataRow drr in SourceTemList.Rows) { if (!string.IsNullOrEmpty(Convert.ToString(drr["TargetTemplateID"]))) { bsbll.RefreshTemplateByGuid(Convert.ToString(drr["TargetTemplateID"])); } } } } } } ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connsucad", "layer.alert('数据源修改成功!');", true); Page.Response.Redirect("DataSourceManage.aspx"); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connerrorae", "layer.alert('数据源修改失败!');", true); } } } catch (Exception ee) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "saveerror", "layer.alert('" + ee.Message + "');", true); } }