/// <summary> /// 得到一个对象实体 /// </summary> public CMICT.CSP.Model.BS_DATASOURCE GetModel(Guid SourceID) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from BS_DATASOURCE "); strSql.Append(" where SourceID=@SourceID"); SqlParameter[] parameters = { new SqlParameter("@SourceID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = SourceID; CMICT.CSP.Model.BS_DATASOURCE model = new CMICT.CSP.Model.BS_DATASOURCE(); DataSet ds = dbhelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(CMICT.CSP.Model.BS_DATASOURCE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BS_DATASOURCE("); strSql.Append("SourceID,SourceName,SourceDesc,BigCategory,SmallCategory,SourceIP,UserName,Password,DBName,ObjectType,ObjectName,SourceCNName,SourceStatus,Created,Modified,Author,Editor)"); strSql.Append(" values ("); strSql.Append("@SourceID,@SourceName,@SourceDesc,@BigCategory,@SmallCategory,@SourceIP,@UserName,@Password,@DBName,@ObjectType,@ObjectName,@SourceCNName,@SourceStatus,@Created,@Modified,@Author,@Editor)"); SqlParameter[] parameters = { new SqlParameter("@SourceID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@SourceName", SqlDbType.NVarChar, 50), new SqlParameter("@SourceDesc", SqlDbType.NVarChar, 200), new SqlParameter("@BigCategory", SqlDbType.NVarChar, 50), new SqlParameter("@SmallCategory", SqlDbType.NVarChar, 200), new SqlParameter("@SourceIP", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Password", SqlDbType.NVarChar, 50), new SqlParameter("@DBName", SqlDbType.NVarChar, 50), new SqlParameter("@ObjectType", SqlDbType.NVarChar, 50), new SqlParameter("@ObjectName", SqlDbType.NVarChar, 50), new SqlParameter("@SourceCNName", SqlDbType.NVarChar, 200), new SqlParameter("@SourceStatus", SqlDbType.NVarChar, 50), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Modified", SqlDbType.DateTime), new SqlParameter("@Author", SqlDbType.NVarChar, 50), new SqlParameter("@Editor", SqlDbType.NVarChar, 50) }; parameters[0].Value = Guid.NewGuid(); parameters[1].Value = model.SourceName; parameters[2].Value = model.SourceDesc; parameters[3].Value = model.BigCategory; parameters[4].Value = model.SmallCategory; parameters[5].Value = model.SourceIP; parameters[6].Value = model.UserName; parameters[7].Value = model.Password; parameters[8].Value = model.DBName; parameters[9].Value = model.ObjectType; parameters[10].Value = model.ObjectName; parameters[11].Value = model.SourceCNName; parameters[12].Value = model.SourceStatus; parameters[13].Value = model.Created; parameters[14].Value = model.Modified; parameters[15].Value = model.Author; parameters[16].Value = model.Editor; int rows = dbhelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(Guid SourceID) { CMICT.CSP.BLL.BS_DATASOURCEBLL bll = new CMICT.CSP.BLL.BS_DATASOURCEBLL(); CMICT.CSP.Model.BS_DATASOURCE model = bll.GetModel(SourceID); if (model != null) { this.txtSourceName.Value = model.SourceName; this.txtSourceIP.Value = model.SourceIP; this.txtUserName.Value = model.UserName; this.txtPwd.Text = model.Password; this.txtSourceDesc.Value = model.SourceDesc; this.txtPwd.Attributes.Add("value", model.Password); string SourceIP = txtSourceIP.Value.Trim(); string UserName = txtUserName.Value.Trim(); string Pwd = txtPwd.Text.Trim(); string DBName = model.DBName; string ObjectType = model.ObjectType; this.hidSourceStatus.Value = model.SourceStatus; ddlObjectType.SelectedValue = model.ObjectType; if (model.SourceStatus.Trim() == "ENABLE") { string temnames = GetTemplateInfoBySourceID(SourceID.ToString()); hidtemnames.Value = temnames; } try { string tipcontent = string.Empty; TestConn(out tipcontent, 1); ddlDBName.SelectedValue = model.DBName; BindObjectName(); ddlObjectName.SelectedValue = model.ObjectName; ddlCATEGORY.SelectedValue = model.BigCategory; txtCATEGORY.Text = model.BigCategory; BindSmallCategory(model.BigCategory); ddlsmallcategory.SelectedValue = model.SmallCategory; txtsmallcategory.Text = model.SmallCategory; ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connsuc", "executeconnectsur();", true); } catch { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "connsuc", "layer.alert('数据源连接不上!无法修改!');", true); } this.txtDBName.Text = model.DBName; this.txtObjectType.Text = model.ObjectType; this.txtObjectName.Text = model.ObjectName; hidauthor.Value = model.Author; hidcreated.Value = model.Created.ToString(); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CMICT.CSP.Model.BS_DATASOURCE GetModel(string temid) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from BS_DATASOURCE "); strSql.Append(" where SourceID=(select SourceID from BS_TEMPLATE_MAIN where TemplateID='" + temid + "')"); CMICT.CSP.Model.BS_DATASOURCE model = new CMICT.CSP.Model.BS_DATASOURCE(); DataSet ds = dbhelper.ExecuteDataSet(CommandType.Text, strSql.ToString(), null); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void ShowInfo(string sourceID) { BindBigCategory(); if (!string.IsNullOrEmpty(sourceID)) { BS_DATASOURCEBLL bll = new BS_DATASOURCEBLL(); CMICT.CSP.Model.BS_DATASOURCE model = bll.GetModel(Guid.Parse(sourceID)); if (model != null) { hidOperType.Value = "edit"; ddlCATEGORY.SelectedValue = model.BigCategory; BindSmallCategory(model.BigCategory); ddlsmallcategory.SelectedValue = model.SmallCategory; BindDataSource(model.BigCategory, model.SmallCategory); ddlSourceName.SelectedValue = model.SourceID.ToString(); txtCATEGORY.Text = model.BigCategory; txtsmallcategory.Text = model.SmallCategory; txtSourceName.Text = model.SourceName; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public CMICT.CSP.Model.BS_DATASOURCE DataRowToModel(DataRow row) { CMICT.CSP.Model.BS_DATASOURCE model = new CMICT.CSP.Model.BS_DATASOURCE(); if (row != null) { if (row["SourceID"] != null && row["SourceID"].ToString() != "") { model.SourceID = new Guid(row["SourceID"].ToString()); } if (row["SourceName"] != null) { model.SourceName = row["SourceName"].ToString(); } if (row["SourceDesc"] != null) { model.SourceDesc = row["SourceDesc"].ToString(); } if (row["BigCategory"] != null) { model.BigCategory = row["BigCategory"].ToString(); } if (row["SmallCategory"] != null) { model.SmallCategory = row["SmallCategory"].ToString(); } if (row["SourceIP"] != null) { model.SourceIP = row["SourceIP"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["DBName"] != null) { model.DBName = row["DBName"].ToString(); } if (row["ObjectType"] != null) { model.ObjectType = row["ObjectType"].ToString(); } if (row["ObjectName"] != null) { model.ObjectName = row["ObjectName"].ToString(); } if (row["SourceCNName"] != null) { model.SourceCNName = row["SourceCNName"].ToString(); } if (row["SourceStatus"] != null) { model.SourceStatus = row["SourceStatus"].ToString(); } if (row["Created"] != null && row["Created"].ToString() != "") { model.Created = DateTime.Parse(row["Created"].ToString()); } if (row["Modified"] != null && row["Modified"].ToString() != "") { model.Modified = DateTime.Parse(row["Modified"].ToString()); } if (row["Author"] != null) { model.Author = row["Author"].ToString(); } if (row["Editor"] != null) { model.Editor = row["Editor"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CMICT.CSP.Model.BS_DATASOURCE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BS_DATASOURCE set "); strSql.Append("SourceID=@SourceID,"); strSql.Append("SourceName=@SourceName,"); strSql.Append("SourceDesc=@SourceDesc,"); strSql.Append("BigCategory=@BigCategory,"); strSql.Append("SmallCategory=@SmallCategory,"); strSql.Append("SourceIP=@SourceIP,"); strSql.Append("UserName=@UserName,"); strSql.Append("Password=@Password,"); strSql.Append("DBName=@DBName,"); strSql.Append("ObjectType=@ObjectType,"); strSql.Append("ObjectName=@ObjectName,"); strSql.Append("SourceCNName=@SourceCNName,"); strSql.Append("SourceStatus=@SourceStatus,"); strSql.Append("Created=@Created,"); strSql.Append("Modified=@Modified,"); strSql.Append("Author=@Author,"); strSql.Append("Editor=@Editor"); strSql.Append(" where SourceID=@SourceID "); SqlParameter[] parameters = { new SqlParameter("@SourceID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@SourceName", SqlDbType.NVarChar, 50), new SqlParameter("@SourceDesc", SqlDbType.NVarChar, 200), new SqlParameter("@BigCategory", SqlDbType.NVarChar, 50), new SqlParameter("@SmallCategory", SqlDbType.NVarChar, 200), new SqlParameter("@SourceIP", SqlDbType.NVarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Password", SqlDbType.NVarChar, 50), new SqlParameter("@DBName", SqlDbType.NVarChar, 50), new SqlParameter("@ObjectType", SqlDbType.NVarChar, 50), new SqlParameter("@ObjectName", SqlDbType.NVarChar, 50), new SqlParameter("@SourceCNName", SqlDbType.NVarChar, 200), new SqlParameter("@SourceStatus", SqlDbType.NVarChar, 50), new SqlParameter("@Created", SqlDbType.DateTime), new SqlParameter("@Modified", SqlDbType.DateTime), new SqlParameter("@Author", SqlDbType.NVarChar, 50), new SqlParameter("@Editor", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.SourceID; parameters[1].Value = model.SourceName; parameters[2].Value = model.SourceDesc; parameters[3].Value = model.BigCategory; parameters[4].Value = model.SmallCategory; parameters[5].Value = model.SourceIP; parameters[6].Value = model.UserName; parameters[7].Value = model.Password; parameters[8].Value = model.DBName; parameters[9].Value = model.ObjectType; parameters[10].Value = model.ObjectName; parameters[11].Value = model.SourceCNName; parameters[12].Value = model.SourceStatus; parameters[13].Value = model.Created; parameters[14].Value = model.Modified; parameters[15].Value = model.Author; parameters[16].Value = model.Editor; int rows = dbhelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
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); } }