private void ShowInfo(Guid TemplateID)
{
CMICT.CSP.BLL.BS_TEMPLATE_MAINBLL bll = new CMICT.CSP.BLL.BS_TEMPLATE_MAINBLL();
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = bll.GetModel(TemplateID);
if (model != null)
{
this.txtTemplateName.Value = model.TemplateName;
this.txtTemplateDesc.Value = model.TemplateDesc;
this.txtPageSize.Value = model.PageSize.ToString();
ddlCATEGORY.SelectedValue = model.BigCategory;
txtCATEGORY.Text = model.BigCategory;
BindSmallCategory(ddlCATEGORY.SelectedValue);
ddlsmallcategory.SelectedValue = model.SmallCategory;
txtsmallcategory.Text = model.SmallCategory;
ddlPageSize.SelectedValue = model.PageSize.ToString();
//txtPageSize.Value = model.PageSize.ToString();
txtUnit.Value = model.Unit;
if (model.TemplateStatus == "DISABLE")
{
chkDisabled.Checked = true;
}
hidDisabled.Value = model.TemplateStatus;
lblpageinfo.Text = GetPageInfoByTemplateID(TemplateID.ToString());
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CMICT.CSP.Model.BS_TEMPLATE_MAIN GetModel(Guid TemplateID)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from BS_TEMPLATE_MAIN ");
strSql.Append(" where TemplateID=@TemplateID");
SqlParameter[] parameters =
{
new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = TemplateID;
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = new CMICT.CSP.Model.BS_TEMPLATE_MAIN();
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 CMICT.CSP.Model.BS_TEMPLATE_MAIN GetModel(Guid TemplateID)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TemplateID,SourceID,TemplateName,DiaplayType,TemplateDesc,Reminder,PageSize,ColumnSize,TemplateStatus,SQL,Created,Modified,Author,Editor from BS_TEMPLATE_MAIN ");
strSql.Append(" where TemplateID=@TemplateID");
SqlParameter[] parameters =
{
new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = TemplateID;
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = new CMICT.CSP.Model.BS_TEMPLATE_MAIN();
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);
}
}
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>");
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CMICT.CSP.Model.BS_TEMPLATE_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BS_TEMPLATE_MAIN(");
strSql.Append("TemplateID,SourceID,TemplateName,DiaplayType,TemplateDesc,Reminder,PageSize,ColumnSize,TemplateStatus,SQL,Created,Modified,Author,Editor)");
strSql.Append(" values (");
strSql.Append("@TemplateID,@SourceID,@TemplateName,@DiaplayType,@TemplateDesc,@Reminder,@PageSize,@ColumnSize,@TemplateStatus,@SQL,@Created,@Modified,@Author,@Editor)");
SqlParameter[] parameters =
{
new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@SourceID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@TemplateName", SqlDbType.NVarChar, 50),
new SqlParameter("@DiaplayType", SqlDbType.NVarChar, 50),
new SqlParameter("@TemplateDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@Reminder", SqlDbType.NVarChar, 50),
new SqlParameter("@PageSize", SqlDbType.Decimal, 9),
new SqlParameter("@ColumnSize", SqlDbType.Decimal, 9),
new SqlParameter("@TemplateStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@SQL", SqlDbType.NVarChar, 4000),
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 = Guid.NewGuid();
parameters[2].Value = model.TemplateName;
parameters[3].Value = model.DiaplayType;
parameters[4].Value = model.TemplateDesc;
parameters[5].Value = model.Reminder;
parameters[6].Value = model.PageSize;
parameters[7].Value = model.ColumnSize;
parameters[8].Value = model.TemplateStatus;
parameters[9].Value = model.SQL;
parameters[10].Value = model.Created;
parameters[11].Value = model.Modified;
parameters[12].Value = model.Author;
parameters[13].Value = model.Editor;
int rows = dbhelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo(Guid TemplateID)
{
CMICT.CSP.BLL.BS_TEMPLATE_MAINBLL bll = new CMICT.CSP.BLL.BS_TEMPLATE_MAINBLL();
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = bll.GetModel(TemplateID);
if (model != null)
{
this.txtTemplateName.Value = model.TemplateName;
this.txtTemplateDesc.Value = model.TemplateDesc;
this.txtPageSize.Value = model.PageSize.ToString();
if (model.TemplateStatus == "禁用")
{
chkDisabled.Checked = true;
}
hidDisabled.Value = model.TemplateStatus;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
string bname = Page.Server.UrlDecode(Page.Request.QueryString["bname"]);
string sname = Page.Server.UrlDecode(Page.Request.QueryString["sname"]);
//BindBigCategory();
if (!string.IsNullOrEmpty(Page.Request.QueryString["sourceID"]))
{
hidsourceid.Value = Page.Request.QueryString["sourceID"];
ShowInfo(Page.Request.QueryString["sourceID"]);
}
else
{
string TemplateID = Page.Request.QueryString["templateID"];
if (!string.IsNullOrEmpty(TemplateID))
{
BS_TEMPLATE_MAINBLL mbll = new BS_TEMPLATE_MAINBLL();
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = mbll.GetModel(Guid.Parse(TemplateID));
if (model != null)
{
BindBigCategory(bname, sname);
//ddlCATEGORY.SelectedValue = model.BigCategory;
// ddlsmallcategory.SelectedValue = model.SmallCategory;
BindDataSource(txtCATEGORY.Text, txtsmallcategory.Text);
// txtCATEGORY.Text = model.BigCategory;
//txtsmallcategory.Text = model.SmallCategory;
}
}
}
}
}
catch (Exception ex)
{
BaseComponent.Error("DataSourceConfig-PageLoad:" + ex.Message);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "dsorceconfigerror", "layer.alert('页面加载出错，请联系管理员！',8);", true);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CMICT.CSP.Model.BS_TEMPLATE_MAIN DataRowToModel(DataRow row)
{
CMICT.CSP.Model.BS_TEMPLATE_MAIN model = new CMICT.CSP.Model.BS_TEMPLATE_MAIN();
if (row != null)
{
if (row["TemplateID"] != null && row["TemplateID"].ToString() != "")
{
model.TemplateID = new Guid(row["TemplateID"].ToString());
}
if (row["SourceID"] != null && row["SourceID"].ToString() != "")
{
model.SourceID = new Guid(row["SourceID"].ToString());
}
if (row["TemplateName"] != null)
{
model.TemplateName = row["TemplateName"].ToString();
}
if (row["DiaplayType"] != null)
{
model.DiaplayType = row["DiaplayType"].ToString();
}
if (row["TemplateDesc"] != null)
{
model.TemplateDesc = row["TemplateDesc"].ToString();
}
if (row["BigCategory"] != null)
{
model.BigCategory = row["BigCategory"].ToString();
}
if (row["SmallCategory"] != null)
{
model.SmallCategory = row["SmallCategory"].ToString();
}
if (row["Unit"] != null)
{
model.Unit = row["Unit"].ToString();
}
if (row["Reminder"] != null)
{
model.Reminder = row["Reminder"].ToString();
}
if (row["PageSize"] != null && row["PageSize"].ToString() != "")
{
model.PageSize = decimal.Parse(row["PageSize"].ToString());
}
if (row["ColumnSize"] != null && row["ColumnSize"].ToString() != "")
{
model.ColumnSize = decimal.Parse(row["ColumnSize"].ToString());
}
if (row["TemplateStatus"] != null)
{
model.TemplateStatus = row["TemplateStatus"].ToString();
}
if (row["SQL"] != null)
{
model.SQL = row["SQL"].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_TEMPLATE_MAIN model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BS_TEMPLATE_MAIN set ");
strSql.Append("TemplateID=@TemplateID,");
strSql.Append("SourceID=@SourceID,");
strSql.Append("TemplateName=@TemplateName,");
strSql.Append("DiaplayType=@DiaplayType,");
strSql.Append("TemplateDesc=@TemplateDesc,");
strSql.Append("BigCategory=@BigCategory,");
strSql.Append("SmallCategory=@SmallCategory,");
strSql.Append("Unit=@Unit,");
strSql.Append("Reminder=@Reminder,");
strSql.Append("PageSize=@PageSize,");
strSql.Append("ColumnSize=@ColumnSize,");
strSql.Append("TemplateStatus=@TemplateStatus,");
strSql.Append("SQL=@SQL,");
strSql.Append("Created=@Created,");
strSql.Append("Modified=@Modified,");
strSql.Append("Author=@Author,");
strSql.Append("Editor=@Editor");
strSql.Append(" where TemplateID=@TemplateID ");
SqlParameter[] parameters =
{
new SqlParameter("@TemplateID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@SourceID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@TemplateName", SqlDbType.NVarChar, 50),
new SqlParameter("@DiaplayType", SqlDbType.NVarChar, 50),
new SqlParameter("@TemplateDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@BigCategory", SqlDbType.NVarChar, 50),
new SqlParameter("@SmallCategory", SqlDbType.NVarChar, 50),
new SqlParameter("@Unit", SqlDbType.NVarChar, 50),
new SqlParameter("@Reminder", SqlDbType.NVarChar, 50),
new SqlParameter("@PageSize", SqlDbType.Decimal, 9),
new SqlParameter("@ColumnSize", SqlDbType.Decimal, 9),
new SqlParameter("@TemplateStatus", SqlDbType.NVarChar, 50),
new SqlParameter("@SQL", SqlDbType.NVarChar, 4000),
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.TemplateID;
parameters[1].Value = model.SourceID;
parameters[2].Value = model.TemplateName;
parameters[3].Value = model.DiaplayType;
parameters[4].Value = model.TemplateDesc;
parameters[5].Value = model.BigCategory;
parameters[6].Value = model.SmallCategory;
parameters[7].Value = model.Unit;
parameters[8].Value = model.Reminder;
parameters[9].Value = model.PageSize;
parameters[10].Value = model.ColumnSize;
parameters[11].Value = model.TemplateStatus;
parameters[12].Value = model.SQL;
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 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);
}
}
