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"); }