public void InitTemplate(string strBillTypeCode)
{
string strSql = "Select * From tb_BillTemplate Where BillTypeCode = '" + strBillTypeCode + "'";
try
{
DataTable dt = dataOper.GetDataTable(strSql, "tb_BillTemplate");
foreach (DataRow dr in dt.Rows)
{
ctxt = new CTextBox();
ctxt.IsFlag = dr["IsFlag"].ToString();
ctxt.Text = dr["ControlName"].ToString();
ctxt.ControlId = Convert.ToInt32(dr["ControlId"]);
ctxt.FormParent = this;
ctxt.DefaultValue = dr["DefaultValue"].ToString();
ctxt.ControlName = dr["ControlName"].ToString();
ctxt.TurnControlName = dr["TurnControlName"].ToString();
ctxt.Location = new Point(Convert.ToInt32(dr["X"]), Convert.ToInt32(dr["Y"]));
ctxt.Size = new Size(Convert.ToInt32(dr["Width"]), Convert.ToInt32(dr["Height"]));
ctxt.ReadOnly = true;
this.Controls.Add(ctxt);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
}
public void InitTemplate(string strBillTypeCode)
{
string strSql = "Select * From tb_BillTemplate Where BillTypeCode = '" + strBillTypeCode + "'";
try
{
DataTable dt = dataOper.GetDataTable(strSql, "tb_BillTemplate");
foreach (DataRow dr in dt.Rows)
{
ctxt = new CTextBox();
ctxt.ContextMenuStrip = null;
ctxt.IsFlag = dr["IsFlag"].ToString();
ctxt.ControlId = Convert.ToInt32(dr["ControlId"]);
ctxt.Location = new Point(Convert.ToInt32(dr["X"]), Convert.ToInt32(dr["Y"]));
ctxt.Size = new Size(Convert.ToInt32(dr["Width"]), Convert.ToInt32(dr["Height"]));
ctxt.ControlName = dr["ControlName"].ToString();
if (ctxt.IsFlag == "1") //若是单据号码对应的控件
{
ctxtExpressBillCode = ctxt; //得到表示快递单号的CTextBox
ctxt.Font = new Font(new FontFamily("宋体"), 9, FontStyle.Bold);
ctxt.MaxLength = Convert.ToInt32(dtBillType.Rows[0]["BillCodeLength"]);
}
this.panelBillPictrue.Controls.Add(this.ctxt);
}
this.panelBillPictrue.Controls.Add(this.pbxBillPicture);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
}
public bool IsExistExpressBillCode(string strExpressBillCode, string strBillTypeCode)
{
DataOperate dataOper = new DataOperate();
try
{
//创建泛型
List <SqlParameter> parameters = new List <SqlParameter>();
//创建SqlParameter对象，并赋值
SqlParameter paramExpressBillCode = new SqlParameter("@ExpressBillCode", SqlDbType.VarChar);
paramExpressBillCode.Value = strExpressBillCode;
parameters.Add(paramExpressBillCode);
//---
SqlParameter paramBillTypeCode = new SqlParameter("@BillTypeCode", SqlDbType.VarChar);
paramBillTypeCode.Value = strBillTypeCode;
parameters.Add(paramBillTypeCode);
//把泛型中的元素复制到数组中
SqlParameter[] inputParameters = parameters.ToArray();
DataTable dt = dataOper.GetDataTable("IsExistExpressBillCode", inputParameters);
if (Convert.ToInt32(dt.Rows[0][0]) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
}
float fDpiY; //记录垂直分辨率
public void InitTemplate(string strBillTypeCode) //动态创建文本输入框
{
//定义获取指定单据编号信息的SQL语句
string strSql = "Select * From tb_BillTemplate Where BillTypeCode = '" + strBillTypeCode + "'";
try
{
//将获取到的信息存储到DataTable中
DataTable dt = dataOper.GetDataTable(strSql, "tb_BillTemplate");
foreach (DataRow dr in dt.Rows) //遍历所有行
{
ctxt = new CTextBox(); //实例化自定义控件对象
ctxt.IsFlag = dr["IsFlag"].ToString(); //是否为对应控件
ctxt.Text = dr["ControlName"].ToString(); //设置控件名称
ctxt.ControlId = Convert.ToInt32(dr["ControlId"]); //设置控件ID
ctxt.FormParent = this; //设置控件所属窗体
ctxt.DefaultValue = dr["DefaultValue"].ToString(); //设置控件默认值
ctxt.ControlName = dr["ControlName"].ToString(); //设置控件默认名称
ctxt.TurnControlName = dr["TurnControlName"].ToString(); //设置控件转换后的名称
//设置控件位置
ctxt.Location = new Point(Convert.ToInt32(dr["X"]), Convert.ToInt32(dr["Y"]));
ctxt.Size = new Size(Convert.ToInt32(dr["Width"]),
Convert.ToInt32(dr["Height"])); //设置控件大小
ctxt.ReadOnly = true; //设置控件只读
this.Controls.Add(ctxt); //将控件添加到当前窗体中
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
}
private void FormExpressBill_Load(object sender, EventArgs e)
{
try
{
DataTable dt = dataOper.GetDataTable("Select BillTypeCode,BillTypeName From tb_BillType", "tb_BillType");
for (int i = 0; i < dt.Rows.Count; i++)
{
toolcbxBillTypeCode.Items.Insert(i, dt.Rows[i]["BillTypeName"]);
dicKeyValue.Add(i, dt.Rows[i]["BillTypeCode"]); //使用IDictionary泛型封装“客户基础分类”信息
}
if (toolcbxBillTypeCode.Items.Count > 0)
{
toolcbxBillTypeCode.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
}
float fDpiY; //记录垂直分辨率
public void InitTemplate(string strBillTypeCode)
{
//定义根据编号获取模板的SQL语句
string strSql = "Select * From tb_BillTemplate Where BillTypeCode = '" + strBillTypeCode + "'";
try
{
//获取模板信息
DataTable dt = dataOper.GetDataTable(strSql, "tb_BillTemplate");
foreach (DataRow dr in dt.Rows) //遍历获取到的所有行
{
ctxt = new CTextBox(); //实例化自定义控件对象
ctxt.ContextMenuStrip = null; //设置快捷菜单为空
ctxt.IsFlag = dr["IsFlag"].ToString(); //是否为对应控件
ctxt.ControlId = Convert.ToInt32(dr["ControlId"]); //设置控件ID
//设置控件位置
ctxt.Location = new Point(Convert.ToInt32(dr["X"]), Convert.ToInt32(dr["Y"]));
//设置控件大小
ctxt.Size = new Size(Convert.ToInt32(dr["Width"]),
Convert.ToInt32(dr["Height"]));
ctxt.ControlName = dr["ControlName"].ToString(); //设置控件默认名称
if (ctxt.IsFlag == "1") //若是单据号码对应的控件
{
ctxtExpressBillCode = ctxt; //得到表示快递单号的CTextBox
//设置控件的字体
ctxt.Font = new Font(new FontFamily("宋体"), 9, FontStyle.Bold);
//设置控件的最大长度
ctxt.MaxLength = Convert.ToInt32(dtBillType.Rows[0]["BillCodeLength"]);
}
this.panelBillPicture.Controls.Add(this.ctxt);//将控件添加到Panel容器中
}
//将图片添加到Panel容器中
this.panelBillPicture.Controls.Add(this.pbxBillPicture);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
}
}
/// <summary>
/// 判断数据表中记录的主键值是否存在外键约束
/// </summary>
/// <param name="strPrimaryTable">主键表</param>
/// <param name="strPrimaryValue">数据表中某条记录主键的值</param>
/// <returns></returns>
public bool IsExistConstraint(string strPrimaryTable, string strPrimaryValue)
{
DataOperate dataOper = new DataOperate();
bool booIsExist = false;
string strSql = null;
string strForeignColumn = null;
string strForeignTable = null;
SqlDataReader sdr = null;
try
{
//创建SqlParameter对象，并赋值
SqlParameter param = new SqlParameter("@PrimaryTable", SqlDbType.VarChar);
param.Value = strPrimaryTable;
//创建泛型
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(param);
//把泛型中的元素复制到数组中
SqlParameter[] inputParameters = parameters.ToArray();
//通过存储过程得到外键表的相关数据
DataTable dt = dataOper.GetDataTable("QueryForeignConstraint", inputParameters);
//循环这些相关数据
foreach (DataRow dr in dt.Rows)
{
strForeignTable = dr["ForeignTable"].ToString();
strForeignColumn = dr["ForeignColumn"].ToString();
strSql = "Select " + strForeignColumn + " From " + strForeignTable + " Where " + strForeignColumn + " = '" + strPrimaryValue + "'";
sdr = dataOper.GetDataReader(strSql);
if (sdr.HasRows)
{
booIsExist = true;
sdr.Close();
//跳出循环
break;
}
sdr.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
return(booIsExist);
}
private void FormExpressBill_Load(object sender, EventArgs e)
{
try
{
//获取单据类型数据源
DataTable dt = dataOper.GetDataTable("Select BillTypeCode,BillTypeName From tb_BillType", "tb_BillType");
for (int i = 0; i < dt.Rows.Count; i++)//循环读取数据源
{
//向下拉列表中添加项
toolcbxBillTypeCode.Items.Insert(i, dt.Rows[i]["BillTypeName"]);
//使用IDictionary泛型封装“快递单类别编号”信息
dicKeyValue.Add(i, dt.Rows[i]["BillTypeCode"]);
}
if (toolcbxBillTypeCode.Items.Count > 0) //若存在单据种类记录
{
toolcbxBillTypeCode.SelectedIndex = 0; //设置当前项索引为0
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "软件提示");
throw ex;
}
}
/// <summary>
/// ListBox控件绑定到数据源
/// </summary>
/// <param name="cbx"></param>
/// <param name="strValueColumn"></param>
/// <param name="strDisplayColumn"></param>
/// <param name="strSql"></param>
/// <param name="strTableName"></param>
public void ListBoxBindDataSource(ListBox lbx, string strValueColumn, string strDisplayColumn, string strSql, string strTableName)
{
DataOperate dataOper = new DataOperate();
try
{
lbx.BeginUpdate();
lbx.DataSource = dataOper.GetDataTable(strSql, strTableName);
lbx.DisplayMember = strDisplayColumn;
lbx.ValueMember = strValueColumn;
lbx.EndUpdate();
}
catch (Exception e)
{
MessageBox.Show(e.Message, "软件提示");
throw e;
}
}
public void BuildImageData(string strBillTypeCode)
{
dtBillType = dataOper.GetDataTable("Select * From tb_BillType Where BillTypeCode = '" + strBillTypeCode + "'", "tb_BillType");
dtBillTemplate = dataOper.GetDataTable("Select * From tb_BillTemplate Where BillTypeCode = '" + strBillTypeCode + "'", "tb_BillTemplate");
}
