/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
#region 赋值实体
Model.QB_ModelEL qbmodel = new Model.QB_ModelEL();
qbmodel.MainID = 0;
qbmodel.Valid = 1;
qbmodel.ImgWidth = 149;
qbmodel.ImgHeight = 149;
qbmodel.QBHeight = 149;
qbmodel.QBWidth = 149;
qbmodel.FontSize = 12;
qbmodel.ENTag = tb_entag.Text;
qbmodel.ModelName = tb_modelName.Text.Trim();
if (hidModel.Value == "0")//3*6
{
qbmodel.Padding = "18px 25px 18px 20px";
qbmodel.QBHeight = 216;
qbmodel.PrintW = 3;
qbmodel.PrintH = 6;
}
else if (hidModel.Value == "1")//3*7
{
qbmodel.Padding = "0px 25px 0px 20px";
qbmodel.QBHeight = 216;
qbmodel.PrintW = 3;
qbmodel.PrintH = 7;
}
#endregion
BLL.QBModelBLL bll_qbmodel = new BLL.QBModelBLL();
if (Request.QueryString["id"] != null)
{
qbmodel.ID = long.Parse(Request.QueryString["id"]);
}
Model.QB_ModelEL qbTmplt = new Model.QB_ModelEL()
{
ENTag = tb_entag.Text.Trim()
};
if (Request.QueryString["id"] != null)
{
qbTmplt.ID = long.Parse(Request.QueryString["id"].Trim());
qbTmplt.ExecuteEL(53);
}
else
{
qbTmplt.ExecuteEL(52);
}
if (qbTmplt.ID > 0 && qbTmplt.MainID > 0)
{
MessageBox.Show(this, "前缀已经使用请重新输入！");
return;
}
if (Request.QueryString["id"] != null)
{
#region 编辑 删除此原来模板的内容 添加新的内容
qbmodel.ExecNonQuery(2);
List <string> qbmodeldetailstr = getQBModelDetail();
Model.QB_ModelDetailEL modeldetail = new Model.QB_ModelDetailEL();
modeldetail.QBID = qbmodel.ID;
modeldetail.ExecNonQuery(31);//删除此原来模板的内容
modeldetail.MainID = 0;
modeldetail.QBID = qbmodel.ID;
foreach (string strdetail in qbmodeldetailstr)//循环添加新的内容
{
modeldetail.QBDetail = strdetail;
modeldetail.ExecNonQuery(1);
}
#endregion
}
else
{
//判断是否存在该名称的模板
if (bll_qbmodel.ExistsModel(qbmodel.ModelName, qbmodel.ID))
{
BLL.Common.MessageBox.Show(this, "已存在相同名称的模板！");
return;
}
#region 新增
qbmodel.ExecuteEL(1);//插入记录 得到新插入实体
List <string> qbmodeldetailstr = getQBModelDetail();
Model.QB_ModelDetailEL modeldetail = new Model.QB_ModelDetailEL();
modeldetail.MainID = 0;
modeldetail.QBID = qbmodel.ID;
foreach (string strdetail in qbmodeldetailstr)
{
modeldetail.QBDetail = strdetail;
modeldetail.ExecNonQuery(1);
}
#endregion
}
MessageBox.ShowAndRedirect(this, "保存成功！", "QBModelList.aspx");
}
/// <summary>
/// 生成Html
/// </summary>
protected void GenerateHtml()
{
string sqlWhere = string.Empty;
string pt = GetPrintType();
int pn = GetPrintNumber();
long sid = GetPrintStartId();
long eid = GetPrintEndId();
long tid = GetTemplateId();
string mainIdS = GetQueryString("mainId");
long mainId = 0;
if (mainIdS != string.Empty)
{
mainId = long.Parse(mainIdS);
}
if (!string.IsNullOrEmpty(pt))
{
DataTable dt = new DataTable();
DataTable detailTable = new DataTable();
Model.QB_CodeEL qbCode = new Model.QB_CodeEL();
Model.QB_ModelDetailEL modelDetail = new Model.QB_ModelDetailEL();
if (pt == "newprint")
{
qbCode.MainID = mainId;
qbCode.ID = sid;
qbCode.AssetID = eid;//结束Id
dt = qbCode.ExecDT(54);
}
else if (pt == "oldprint")
{
dt = qbCode.ExecuteSqlString(GetQBCodeSql(pn));
}
modelDetail.MainID = mainId;
modelDetail.QBID = tid;
detailTable = modelDetail.ExecDT(52);
Model.QB_ModelEL model = new Model.QB_ModelEL();
model.ID = tid;
model.ExecuteEL(4);
if (dt != null && dt.Rows.Count > 0)
{
//bool isNewPage = true;
for (int i = 0; i < dt.Rows.Count; i++)
{
#region 2017-8-30 老版本原代码01
//if (isNewPage)
//{
// html.Append("<div style='height:48px;'></div><div class='bar'>");
//}
//html.Append("<div class='bar-code' style='padding:" + (model.Padding == string.Empty ? "0px 25px 0px 20px" : model.Padding) + ";height:" + model.QBHeight.ToString() + "px'>");
//html.Append("<div class='barc-left'>");
//html.Append("<img src='" + dt.Rows[i]["QBPath"] + "' width='" + model.ImgWidth.ToString() + "px' height='" + model.ImgHeight.ToString() + "px' alt=''/>");
//html.Append("<div class='barc-left-code' pkey='code' pvalue='" + dt.Rows[i]["QBCode"] + "' >编号：" + dt.Rows[i]["QBCode"] + "</div>");
//html.Append("</div>");
//html.Append("<div class='barc-right'>");
//if (detailTable.Rows.Count > 0)
//{
// html.Append("<h4>" + detailTable.Rows[0]["QBDetail"] + "</h4>");
// for (int j = 0; j < detailTable.Rows.Count; j++)
// {
// if (j == 0)
// {
// continue;
// }
// html.Append("<p>" + detailTable.Rows[j]["QBDetail"] + "</p>");
// }
//}
//else
//{
// html.Append("<p></p>");
//}
//html.Append("</div>");
#endregion
#region 新代码
//html.Append("<div class='tag' style='padding:" + (model.Padding == string.Empty ? "40px 25px 0px 20px;" : model.Padding) + ";width:" + model.QBWidth + "px;height:" + model.QBHeight + "px;float:left;'>");
//html.Append("<img src='" + dt.Rows[i]["QBPath"] + "' width='" + model.ImgWidth.ToString() + "px' height='" + model.ImgHeight.ToString() + "px' alt=''/>");
//html.Append("<div class='tag-right' style=\"float:right;width:170px;margin-top:10px;margin-right:10px;\">");
//if (detailTable.Rows.Count > 0)
//{
// html.Append("<h4>" + detailTable.Rows[0]["QBDetail"] + "</h4>");
// for (int j = 0; j < detailTable.Rows.Count; j++)
// {
// if (j == 0)
// {
// continue;
// }
// html.Append("<p>" + detailTable.Rows[j]["QBDetail"] + "</p>");
// }
//}
//else
//{
// html.Append("<p></p>");
//}
//html.Append("</div>");
//html.Append("<div style='text-align:center;width:" + model.ImgWidth.ToString() + "px;' pkey='code' pvalue='" + dt.Rows[i]["QBCode"] + "' >编号：" + dt.Rows[i]["QBCode"] + "</div>");
//html.Append("</div>");
//html.Append("</div>");//tag
#endregion
#region 2017-8-30老版本原代码02
//html.Append("</div>");//bar
//if ((i + 1) % (model.PrintW != 0 ? (model.PrintW * model.PrintH) : 21) != 0)
//{
// isNewPage = false;
//}
//else
//{
// isNewPage = true;
// html.Append("</div>");
//}
//if (i == dt.Rows.Count - 1 && (i + 1) % (model.PrintW != 0 ? (model.PrintW * model.PrintH) : 21) != 0)
//{
// html.Append("</div>");
//}
#endregion
#region 版本二
////版本二 2017-9-5
//html.Append("<li>");
//html.Append("<div class='outer'>");
//if (detailTable.Rows.Count > 0)
//{
// html.Append("<span class='tel'>" + detailTable.Rows[0]["QBDetail"] + "</span>");
//}
//html.Append("<div class='inner'>");
//html.Append("<img class='QR' src='" + dt.Rows[i]["QBPath"] + "'>");
//html.Append("<span class='num' pkey='code' pvalue='" + dt.Rows[i]["QBCode"] + "'>编号：" + dt.Rows[i]["QBCode"] + "</span>");
//html.Append("</div>");
//html.Append("</div>");
//html.Append("<div class='PageNext'></div>");
//html.Append("</li>");
#endregion
html.Append("<li>");
html.Append("<div class='outer'>");
if (detailTable.Rows.Count > 0)
{
html.Append("<span class='title'>" + detailTable.Rows[0]["QBDetail"] + "</span>");
html.Append("<span class='tel'>" + detailTable.Rows[1]["QBDetail"] + "</span>");
}
html.Append("<div class='inner'>");
html.Append("<img class='QR' src='" + dt.Rows[i]["QBPath"] + "'>");
html.Append("<div class='num' pkey='code' pvalue='" + dt.Rows[i]["QBCode"] + "'>编号：" + dt.Rows[i]["QBCode"] + "</div>");
html.Append("</div>");
html.Append("</div>");
html.Append("<div class='PageNext'></div>");
html.Append("</li>");
html.Append("");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
Model.QB_ModelEL qbmodel = new Model.QB_ModelEL();
qbmodel.ID = long.Parse(Request.QueryString["id"].ToString());
qbmodel.ExecuteEL(4);
#region 给控件赋值
if (qbmodel.PrintH == 6)
{
hidModel.Value = "0";
}
else
{
hidModel.Value = "1";
}
tb_modelName.Text = qbmodel.ModelName;
tb_entag.Text = qbmodel.ENTag;
ltCode.Text = qbmodel.ENTag + 10000000000.ToString().Substring(qbmodel.ENTag.Trim().Length + 2) + "1";//预览处二维码
DataTable dtModelDetail = new Model.QB_ModelDetailEL()
{
QBID = qbmodel.ID
}.ExecDT(41);
if (dtModelDetail.Rows.Count > 0)
{
othertext1.Text = dtModelDetail.Rows[0]["QBDetail"].ToString();
lt1.Text = dtModelDetail.Rows[0]["QBDetail"].ToString();
try
{
othertext2.Text = dtModelDetail.Rows[1]["QBDetail"].ToString();
lt2.Text = dtModelDetail.Rows[1]["QBDetail"].ToString();
}
catch
{
othertext2.Text = "";
}
//try
//{
// othertext3.Text = dtModelDetail.Rows[2]["QBDetail"].ToString();
// lt3.Text = dtModelDetail.Rows[2]["QBDetail"].ToString();
//}
//catch
//{
// othertext3.Text = "";
//}
//try
//{
// othertext4.Text = dtModelDetail.Rows[3]["QBDetail"].ToString();
// lt4.Text = dtModelDetail.Rows[3]["QBDetail"].ToString();
//}
//catch
//{
// othertext4.Text = "";
//}
//try
//{
// othertext5.Text = dtModelDetail.Rows[4]["QBDetail"].ToString();
// lt5.Text = dtModelDetail.Rows[4]["QBDetail"].ToString();
//}
//catch
//{
// othertext5.Text = "";
//}
//try
//{
// othertext6.Text = dtModelDetail.Rows[5]["QBDetail"].ToString();
// lt6.Text = dtModelDetail.Rows[5]["QBDetail"].ToString();
//}
//catch
//{
// othertext6.Text = "";
//}
}
#endregion
}
}
}
/// <summary>
/// 保存事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string mainIdS = GetQueryString("mainId");
long mainId = 0;
if (mainIdS != string.Empty)
{
mainId = long.Parse(mainIdS);
}
if (mainId > 0)
{
#region 赋值实体
Model.QB_ModelEL qbmodel = new Model.QB_ModelEL();
qbmodel.MainID = mainId;
qbmodel.Valid = 1;
qbmodel.ImgWidth = 149;
qbmodel.ImgHeight = 149;
qbmodel.QBHeight = 149;
qbmodel.QBWidth = 149;
qbmodel.FontSize = 12;
qbmodel.ENTag = tb_entag.Text;
qbmodel.ModelName = tb_modelName.Text.Trim();
if (hidModel.Value == "0")//3*6
{
qbmodel.Padding = "18px 25px 18px 20px";
qbmodel.QBHeight = 216;
qbmodel.PrintW = 3;
qbmodel.PrintH = 6;
}
else if (hidModel.Value == "1")//3*7
{
qbmodel.Padding = "0px 25px 0px 20px";
qbmodel.QBHeight = 216;
qbmodel.PrintW = 3;
qbmodel.PrintH = 7;
}
#endregion
BLL.QBModelBLL bll_qbmodel = new BLL.QBModelBLL();
if (Request.QueryString["id"] != null)
{
qbmodel.ID = long.Parse(Request.QueryString["id"]);
}
if (Request.QueryString["id"] != null)
{
#region 编辑 删除此原来模板的内容 添加新的内容
//判断是否已经有此前缀，有的话则不继续执行
if (hf_entag.Value != tb_entag.Text)
{
if (IshaveENTag())
{
return;
}
}
qbmodel.ExecNonQuery(2);
List <string> qbmodeldetailstr = getQBModelDetail();
Model.QB_ModelDetailEL modeldetail = new Model.QB_ModelDetailEL();
modeldetail.QBID = qbmodel.ID;
modeldetail.ExecNonQuery(31);//删除此原来模板的内容
modeldetail.MainID = mainId;
modeldetail.QBID = qbmodel.ID;
foreach (string strdetail in qbmodeldetailstr)//循环添加新的内容
{
modeldetail.QBDetail = strdetail;
modeldetail.ExecNonQuery(1);
}
#endregion
}
else
{
//判断是否存在该名称的模板
if (bll_qbmodel.ExistsModel(qbmodel.ModelName, qbmodel.ID))
{
BLL.Common.MessageBox.Show(this, "已存在相同名称的模板！");
return;
}
#region 新增
qbmodel.ExecuteEL(1);//插入记录 得到新插入实体
List <string> qbmodeldetailstr = getQBModelDetail();
Model.QB_ModelDetailEL modeldetail = new Model.QB_ModelDetailEL();
modeldetail.MainID = mainId;
modeldetail.QBID = qbmodel.ID;
foreach (string strdetail in qbmodeldetailstr)
{
modeldetail.QBDetail = strdetail;
modeldetail.ExecNonQuery(1);
}
#endregion
}
MessageBox.ShowAndRedirect(this, "保存成功！", "QBModelList.aspx");
}
else
{
MessageBox.Show(this, "没有传入相关参数！");
}
}
