/// <summary>
/// 根据属性
/// </summary>
/// <returns></returns>
public string GetTemplateList(int str)
{
string list = string.Empty;
List <Hi.Model.BD_TemplateAttribute> ll = new Hi.BLL.BD_TemplateAttribute().GetList("", "TemplateID=" + str + " and ISNULL(dr,0)=0 and ComPid=" + this.CompID, "");
if (ll.Count > 0)
{
foreach (Hi.Model.BD_TemplateAttribute item in ll)
{
Hi.Model.BD_Attribute model = new Hi.BLL.BD_Attribute().GetModel(item.AttributeID);
string str2 = model.AttributeName;
if (model.Memo != "")
{
str2 += "(" + model.Memo + ")";
}
list += str2 + "；";
}
if (list.Length > 65)
{
list = list.Substring(0, list.Substring(0, 65).LastIndexOf('；')) + "<br> " + list.Substring(list.Substring(0, 65).LastIndexOf('；'));
}
}
return(list != "" ? list.Substring(0, list.Length - 1) : list);
}
/// <summary>
/// 属性绑定
/// </summary>
private void BindAttribute(int type, string id)
{
int y = 0;
StringBuilder html = new StringBuilder();
StringBuilder html2 = new StringBuilder();
html.Append("<ul class=\"ng-scope\">");
List <Hi.Model.BD_Attribute> ll = new Hi.BLL.BD_Attribute().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID, "");
if (ll.Count > 0)
{
if (type == 2)
{
List <Hi.Model.BD_TemplateAttribute> l = new Hi.BLL.BD_TemplateAttribute().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and templateId=" + id, "");
foreach (Hi.Model.BD_Attribute item in ll)
{
string str = string.Empty;
int attrId = 0;
if (l.Count > 0)
{
foreach (Hi.Model.BD_TemplateAttribute item2 in l)
{
if (item2.AttributeID == item.ID)
{
attrId = item2.ID;
str = "checked=\"checked\"";
break;
}
}
}
html.Append("<li class=\"pointer proHover p-t-6 p-b-6 ng-scope\" tip=\"" + item.ID + "\"><span class=\"customerManager m-l-10\"><input class=\"ng-pristine ng-untouched ng-valid\" " + str + " type=\"checkbox\" name=\"chekAttr\" value=\"" + item.ID + "\"/></span><span class=\"ng-binding\">" + item.AttributeName + "</span>");
if (item.Memo != "")
{
html.Append("<span class=\"ng-binding\">(" + item.Memo + ")</span>");
}
html.Append("</li>");
List <Hi.Model.BD_AttributeValues> lll = new Hi.BLL.BD_AttributeValues().GetList("", "isnull(dr,0)=0 and isenabled=1 and compId=" + this.CompID + " and attributeId=" + item.ID, "");
if (lll.Count > 0)
{
html2.Append("<ul class=\"ng-scope\" tip=\"" + item.ID + "\" " + (y != 0 ? "style=\"display:none;\"" : "") + ">");
foreach (Hi.Model.BD_AttributeValues item2 in lll)
{
string str2 = string.Empty;
if (attrId != 0)
{
List <Hi.Model.BD_TemplateAttrValue> llll = new Hi.BLL.BD_TemplateAttrValue().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and TemplateAttrID=" + attrId + " and attributevalueId=" + item2.ID, "");
if (llll.Count > 0)
{
str2 = "checked=\"checked\"";
}
List <Hi.Model.BD_TemplateAttrValue> lllll = new Hi.BLL.BD_TemplateAttrValue().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and TemplateAttrID=" + attrId, "");
if (lllll.Count == 0)
{
str2 = "checked=\"checked\"";
}
}
html2.Append("<li class=\"pointer proHover p-t-6 p-b-6 ng-scope\" tip=\"" + item2.ID + "\"><span class=\"customerManager m-l-10\"><input class=\"ng-pristine ng-untouched ng-valid\" " + str2 + " type=\"checkbox\" name=\"chekAttrValue" + item.ID + "\" value=\"" + item2.ID + "\"/></span><span class=\"ng-binding\">" + item2.AttrValue + "</span></li>");
y++;
}
html2.Append("</ul>");
}
}
}
else
{
foreach (Hi.Model.BD_Attribute item in ll)
{
html.Append("<li class=\"pointer proHover p-t-6 p-b-6 ng-scope\" tip=\"" + item.ID + "\"><span class=\"customerManager m-l-10\"><input class=\"ng-pristine ng-untouched ng-valid\" type=\"checkbox\" name=\"chekAttr\" value=\"" + item.ID + "\"/></span><span class=\"ng-binding\">" + item.AttributeName + "</span>");
if (item.Memo != "")
{
html.Append("<span class=\"ng-binding\">(" + item.Memo + ")</span>");
}
html.Append("</li>");
List <Hi.Model.BD_AttributeValues> l = new Hi.BLL.BD_AttributeValues().GetList("", "isnull(dr,0)=0 and isenabled=1 and compId=" + this.CompID + " and attributeId=" + item.ID, "");
if (l.Count > 0)
{
html2.Append("<ul class=\"ng-scope\" tip=\"" + item.ID + "\" style=\"display:none;\">");
foreach (Hi.Model.BD_AttributeValues item2 in l)
{
html2.Append("<li class=\"pointer proHover p-t-6 p-b-6 ng-scope\" tip=\"" + item2.ID + "\"><span class=\"customerManager m-l-10\"><input class=\"ng-pristine ng-untouched ng-valid\" type=\"checkbox\" name=\"chekAttrValue" + item.ID + "\" value=\"" + item2.ID + "\"/></span><span class=\"ng-binding\">" + item2.AttrValue + "</span></li>");
}
html2.Append("</ul>");
}
}
}
}
html.Append("</ul>");
this.divAttr.InnerHtml = html.ToString();
this.divAttrValue.InnerHtml = html2.ToString();
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAdd_Click(object sender, EventArgs e)
{
SqlTransaction Tran = null;
try
{
Hi.Model.BD_Template model = null;
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
string str = Request["chekAttr"]; //属性id List
string template = Common.NoHTML(this.txtTemplate.Value.Trim()); //模板名称
object obj = Request["tempId"];
if (obj != null)
{
string tempIds = obj.ToString();
List <Hi.Model.BD_TemplateAttribute> l = new Hi.BLL.BD_TemplateAttribute().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and templateId=" + tempIds, "", Tran);
if (l.Count > 0)
{
foreach (Hi.Model.BD_TemplateAttribute item in l)
{
new Hi.BLL.BD_TemplateAttribute().Delete(item.ID, Tran);
new Hi.BLL.BD_TemplateAttrValue().Delete(item.ID, Tran);
}
}
model = new Hi.BLL.BD_Template().GetModel(Convert.ToInt32(tempIds), Tran);
}
model = new Hi.Model.BD_Template();
model.CompID = this.CompID;
model.CreateDate = DateTime.Now;
model.CreateUserID = this.UserID;
model.modifyuser = this.UserID;
model.TemplateName = template;
model.TemplateCode = "";
model.ts = DateTime.Now;
model.IsEnabled = 1;
int tempId = 0;
if (obj != null)
{
tempId = Convert.ToInt32(obj.ToString());
model.ID = tempId;
new Hi.BLL.BD_Template().Update(model, Tran);
}
else
{
tempId = new Hi.BLL.BD_Template().Add(model, Tran);
}
for (int i = 0; i < str.Split(',').Length; i++)
{
Hi.Model.BD_TemplateAttribute model2 = new Hi.Model.BD_TemplateAttribute();
model2.AttributeID = Convert.ToInt32(str.Split(',')[i]);
model2.CompID = this.CompID;
model2.TemplateID = tempId;
model2.CreateDate = DateTime.Now;
model2.CreateUserID = this.UserID;
model2.ts = DateTime.Now;
model2.modifyuser = this.UserID;
int TemplateAttrId = new Hi.BLL.BD_TemplateAttribute().Add(model2, Tran);
string str2 = Request["chekAttrValue" + str.Split(',')[i]];
for (int x = 0; x < str2.Split(',').Length; x++)
{
Hi.Model.BD_TemplateAttrValue model3 = new Hi.Model.BD_TemplateAttrValue();
model3.CompID = this.CompID;
model3.AttributeValueID = Convert.ToInt32(str2.Split(',')[x]);
model3.TemplateAttrID = TemplateAttrId;
model3.CreateDate = DateTime.Now;
model3.CreateUserID = this.UserID;
model3.ts = DateTime.Now;
model3.modifyuser = this.UserID;
new Hi.BLL.BD_TemplateAttrValue().Add(model3, Tran);
}
}
Tran.Commit();
// Response.Write("<script>window.parent.CloseDialog(\"2\");window.opener.location=window.opener.location;</script>");
this.ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>parent.location.reload();window.parent.CloseDialog(\"2\");</script>");
}
catch (Exception ex)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMethod(this, "保存失败了", JScript.IconOption.错误);
return;
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
SqlTransaction Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
try
{
List <int> l = new List <int>();
foreach (RepeaterItem row in this.rptTemplate.Items)
{
CheckBox cb = row.FindControl("CB_SelItem") as CheckBox;
if (cb != null && cb.Checked)
{
HiddenField fld = row.FindControl("HF_Id") as HiddenField;
if (fld != null)
{
int id = Convert.ToInt32(fld.Value);
l.Add(id);
Hi.Model.BD_Template model = new Hi.BLL.BD_Template().GetModel(id, Tran);
if (model != null)
{
model.ts = DateTime.Now;
model.modifyuser = this.UserID;
model.dr = 1;
model.CompID = this.CompID;
bool bol = new Hi.BLL.BD_Template().Update(model, Tran);
List <Hi.Model.BD_TemplateAttribute> ll = new Hi.BLL.BD_TemplateAttribute().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and templateid=" + model.ID, "", Tran);
if (ll.Count > 0)
{
foreach (Hi.Model.BD_TemplateAttribute item in ll)
{
Hi.Model.BD_TemplateAttribute model2 = new Hi.BLL.BD_TemplateAttribute().GetModel(item.ID);
model2.CompID = this.CompID;
model2.modifyuser = this.UserID;
model2.ts = DateTime.Now;
model2.dr = 1;
new Hi.BLL.BD_TemplateAttribute().Update(model2, Tran);
}
}
}
}
}
}
Tran.Commit();
}
catch (Exception ex)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMethod(this, "删除失败了", JScript.IconOption.错误);
return;
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
Bind();
}
}