/// <summary> /// 将格式保存入数据库 /// </summary> public static int SaveGridToDB(GridView gv, string sName, int iTag) { MemoryStream stream = new MemoryStream(); gv.SaveLayoutToStream(stream); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Format where F_Name = '" + sName + "' and F_Tag = " + iTag.ToString()); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["F_Name"] = sName; dr["F_Tag"] = iTag; dr["F_Stream"] = stream.ToArray(); dr["F_SQL"] = ""; ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["F_Stream"] = stream.ToArray(); dr.EndEdit(); } return(myHelper.SaveData(ds, "select * from t_Format where F_Name = '" + sName + "' and F_Tag = " + iTag.ToString())); }
private void Save() { binData.EndEdit(); if (txtID.Text == "") { MessageBox.Show(this, "规则编码不能为空!", "提示"); txtID.Focus(); return; } if (txtName.Text == "") { MessageBox.Show(this, "规则名称不能为空!", "提示"); txtName.Focus(); return; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(((DataTable)binData.DataSource).DataSet, "select * from t_KQRule") == 0) { MessageBox.Show(this, "数据保存成功!", "提示"); BindData(); } }
public static void SaveToDB(string CurrentForm, MemoryStream s) { string SQL = "select * from t_FormFormat where F_FormName = '" + CurrentForm + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(SQL); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["F_FormName"] = CurrentForm; dr["F_Stream"] = s.ToArray(); ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["F_Stream"] = s.ToArray(); dr.EndEdit(); } myHelper.SaveData(ds, SQL); }
private void SaveReport(DevExpress.XtraReports.UI.XtraReport r) { MemoryStream stream = new MemoryStream(); r.SaveLayout(stream); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Report where FType = '" + this.Name + "'"); DataRow dr = null; if (ds.Tables[0].Rows.Count == 0) { dr = ds.Tables[0].NewRow(); dr["FType"] = this.Name; dr["FName"] = this.Text; dr["FReport"] = stream.ToArray(); dr["FDefault"] = 1; ds.Tables[0].Rows.Add(dr); } else { dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["FReport"] = stream.ToArray(); dr.EndEdit(); } myHelper.SaveData(ds, "select * from t_Report where FType = '" + this.Name + "'"); }
private void frmReportEx_KeyDown(object sender, KeyEventArgs e) { if (e.Control == true && e.KeyCode == Keys.F9) { Common.frmSQL mySQL = new Common.frmSQL(); mySQL.MeSQL.Text = strQuerySQL; if (mySQL.ShowDialog() == DialogResult.OK) { strQuerySQL = mySQL.MeSQL.Text; if (DataBind() == 0) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); string strSQL = "select * from t_UserReport where F_Name = '" + strName + "'"; DataSet ds = myHelper.GetDs(strSQL); ds.Tables[0].Rows[0]["F_SQL"] = strQuerySQL; myHelper.SaveData(ds, strSQL); } } mySQL.Dispose(); } if (e.KeyCode == Keys.F5) { SaveFieldFormat(); } if (e.KeyCode == Keys.F7) { tbSet_Click(null, null); } }
private void sbOK_Click(object sender, EventArgs e) { binUser.EndEdit(); if (textEdit1.Text.Length == 0) { MessageBox.Show("用户代码不能为空!!", "提示"); textEdit1.Focus(); return; } if (textEdit2.Text.Length == 0) { MessageBox.Show("用户名称不能为空!!", "提示"); textEdit2.Focus(); return; } if (lookUpEdit1.Text.Length == 0) { MessageBox.Show("用户组不能为空!!", "提示"); lookUpEdit1.Focus(); return; } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = ((DataView)binUser.DataSource).Table.DataSet; if (myHelper.SaveData(ds, strSaveSQL) == 0) { this.DialogResult = DialogResult.OK; } }
/// <summary> /// 保存 /// </summary> private void Save() { if (txtID.Text.Length == 0) { MessageBox.Show(this, "编号不能为空!!", "提示"); txtID.Focus(); return; } if (txtID.Text.Length == 0) { MessageBox.Show(this, "名称不能为空!!", "提示"); txtID.Focus(); return; } DataSet ds = ((DataView)binMain.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_BalanceType") == 0) { MessageBox.Show(this, "数据保存成功!!", "提示"); ds.AcceptChanges(); } }
/// <summary> /// 保存数据 /// </summary> private void Save() { gvList.PostEditor(); DataSet ds = ((DataView)this.gcList.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); myHelper.SaveData(ds, "select * from t_GenWage where F_Month = '" + GetDate() + "'"); }
private void Save() { binData.EndEdit(); DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(((DataTable)binData.DataSource).DataSet, "select * from t_SetClass") == 0) { MessageBox.Show(this, "数据保存成功!", "提示"); } }
/// <summary> /// 保存数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void sbOK_Click(object sender, EventArgs e) { gvMain.PostEditor(); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = ((DataView)this.gcMain.DataSource).Table.DataSet; if (myHelper.SaveData(ds, "select * from t_WageItem") == 0) { this.DialogResult = DialogResult.OK; } }
private void SaveData() { gvList.PostEditor(); DataSet ds = ((DataView)gcList.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_ProductArrange") == 0) { MessageBox.Show("数据保存成功!!", "提示"); } }
/// <summary> /// 保存数据 /// </summary> private void SaveData() { arrayView.CloseEditor(); DataSet ds = ((DataTable)arrayGrid.DataSource).DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_ArrangeClass") == 0) { MessageBox.Show(this, "数据保存成功!", "提示"); ds.AcceptChanges(); } }
private void tsSave_Click(object sender, EventArgs e) { gvAssist.PostEditor(); gvAssist.CloseEditor(); DataSet ds = ((DataTable)gcAssist.DataSource).DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_Assist") == 0) { ds.AcceptChanges(); } }
private void SaveData() { string strSQL = "select * from t_cwCheckOut where F_Init = 1"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); gridView1.CloseEditor(); binCW.EndEdit(); if (myHelper.SaveData(((DataTable)binCW.DataSource).DataSet, strSQL) == 0) { MessageBox.Show("数据保存成功!!", "提示"); ((DataTable)binCW.DataSource).AcceptChanges(); } }
/// <summary> ///保存数据 /// </summary> private void SaveData() { ViewBillCode.PostEditor(); ViewBillCode.UpdateCurrentRow(); DataSet ds = ((DataView)GridBillCode.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_BillCode") == 0) { MessageBox.Show(this, "数据保存成功!!"); ds.AcceptChanges(); } }
/// <summary> /// 导入Bom单主表资料 /// </summary> /// <param name="values"></param> private void ImportBom(System.Array values) { int len1 = values.GetLength(0); int len2 = values.GetLength(1); DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsBom = myHelper.GetDs("select * from t_Bom"); System.Data.DataTable dt = dsBom.Tables[0]; System.Data.DataTable dtTmp = dt.Copy(); dt.Columns["F_BillID"].Unique = true; string strID; try { for (int i = 1; i < len1; i++) { strID = values.GetValue(i, 1).ToString(); if (strID.Length == 0) { continue; } if (dt.Select("F_BillID = '" + strID + "'").Length > 0) { MessageBox.Show(this, "数据库已存在编码为'" + strID + "'的BOM单号,请检查待导入Excel文件!", "提示"); break; } DataRow drNew = dsBom.Tables[0].NewRow(); drNew["F_BillID"] = values.GetValue(i, 1).ToString(); if (values.GetValue(i, 2).ToString().Length == 0) { drNew["F_Date"] = "1900-1-1"; } else { drNew["F_Date"] = values.GetValue(i, 2).ToString(); } drNew["F_ItemID"] = values.GetValue(i, 3).ToString(); drNew["F_Remark"] = values.GetValue(i, 4).ToString(); dsBom.Tables[0].Rows.Add(drNew); } myHelper.SaveData(dsBom, "select * from t_Bom"); } catch (Exception E) { MessageBox.Show(this, E.Message, "错误"); } }
private void frmReport_KeyDown(object sender, KeyEventArgs e) { if (e.Control == true && e.KeyCode == Keys.F8 && DataLib.SysVar.strUGroup == "超级用户") { PrintDesign(); } if (e.KeyCode == Keys.F7 && DataLib.SysVar.strUGroup == "超级用户") { SetGridFormat(); } if (e.KeyCode == Keys.F5 && DataLib.SysVar.strUGroup == "超级用户") { DataLib.sysClass.SaveGridToDB(gvReport, ReportTag, rgOption.SelectedIndex); //SaveFieldFormat(); } if (e.Control == true && e.KeyCode == Keys.F9 && DataLib.SysVar.strUGroup == "超级用户") { frmSQL mySQL = new frmSQL(); mySQL.MeSQL.Text = strQuerySQL; if (mySQL.ShowDialog() == DialogResult.OK) { strQuerySQL = mySQL.MeSQL.Text; if (BindData() == 0) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); string strSQL = "select * from t_SQL where F_Class = '" + ReportTag + "' and F_Tag = '" + rgOption.SelectedIndex.ToString() + "'"; DataSet ds = myHelper.GetDs(strSQL); if (ds.Tables[0].Rows.Count == 0) { DataRow drNew = ds.Tables[0].NewRow(); drNew["F_Class"] = ReportTag; drNew["F_Tag"] = rgOption.SelectedIndex.ToString(); drNew["F_SQL"] = strQuerySQL; ds.Tables[0].Rows.Add(drNew); } else { ds.Tables[0].Rows[0]["F_SQL"] = strQuerySQL; } myHelper.SaveData(ds, strSQL); } } mySQL.Dispose(); } }
/// <summary> /// 导入外加工厂商资料 /// </summary> /// <param name="values"></param> private void ImportOutSupplier(System.Data.DataTable values) { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsEmp = myHelper.GetDs("select * from t_OutSupplier"); System.Data.DataTable dt = dsEmp.Tables[0]; dt.Columns["F_ID"].Unique = true; string strID = ""; foreach (DataRow dr in values.Rows) { strID = dr["厂商编码"].ToString(); if (strID == "") { continue; } if (dt.Select("F_ID = '" + strID + "'").Length > 0) { MessageBox.Show(this, "数据库已存在编码为'" + strID + "'的外加工厂商,请检查待导入Excel文件!", "提示"); break; } DataRow drNew = dt.NewRow(); drNew["F_ID"] = strID; drNew["F_Name"] = dr["厂商名称"]; drNew["F_Type"] = dr["类别编码"]; drNew["F_LinkMan"] = dr["联系人"]; drNew["F_Tel"] = dr["电话"]; drNew["F_OtherTel"] = dr["其它电话"]; drNew["F_Bank"] = dr["银行"]; drNew["F_BankNo"] = dr["银行帐号"]; drNew["F_PostCode"] = dr["邮编"]; drNew["F_Adr"] = dr["地址"]; drNew["F_Remark"] = dr["备注"]; drNew["F_Use"] = true; drNew["F_QcMoney"] = dr["期初"]; drNew["F_PreMoney"] = dr["预付"]; dt.Rows.Add(drNew); } myHelper.SaveData(dsEmp, "select * from t_OutSupplier"); }
/// <summary> /// 授权 /// </summary> private void SaveRight() { string strSQL = "select * from t_RightDetail where F_Group = '" + lbGroup.Text.ToString() + "' and F_Class = '" + tvRight.SelectedNode.Tag.ToString() + "'"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); DataTable dt = ds.Tables[0]; DataRow drField; int intCnt = ckRight.Items.Count; for (int i = 0; i < intCnt; i++) { DataRow[] dr = dt.Select("F_Name = '" + ckRight.Items[i].Value.ToString() + "'"); if (dr.Length == 0) { drField = dt.NewRow(); drField["F_Group"] = lbGroup.Text.ToString(); drField["F_Class"] = tvRight.SelectedNode.Tag.ToString(); drField["F_Name"] = ckRight.Items[i].Value.ToString(); if (ckRight.Items[i].CheckState == CheckState.Checked) { drField["F_Enable"] = true; } else { drField["F_Enable"] = false; } dt.Rows.Add(drField); } else { drField = dr[0]; if (ckRight.Items[i].CheckState == CheckState.Checked) { drField["F_Enable"] = true; } else { drField["F_Enable"] = false; } } } myHelper.SaveData(ds, strSQL); }
/// <summary> /// 保存权限 /// </summary> /// <returns></returns> private bool SaveRight() { if (gvGroup.FocusedRowHandle < 0) { return(false); } DataRow dr = gvGroup.GetDataRow(gvGroup.FocusedRowHandle); gvRight.PostEditor(); gvRight.UpdateCurrentRow(); DataSet ds = ((DataView)gcRight.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_RightDetail where F_Group = '" + dr["F_Group"].ToString() + "'") == 0) { ds.AcceptChanges(); int intFlag = 0, intFlag1 = 0, intFlag2 = 0, intFlag3 = 0; if (checkBox1.Checked == true) { intFlag = 1; } if (checkBox2.Checked == true) { intFlag1 = 1; } if (checkBox3.Checked == true) { intFlag2 = 1; } if (checkBox4.Checked == true) { intFlag3 = 1; } myHelper.ExecuteSQL("update t_UserGroup set F_View = " + intFlag.ToString() + ",F_Export = " + intFlag1.ToString() + ",F_Print = " + intFlag2.ToString() + ",F_ModiPrice = " + intFlag3.ToString() + " where F_Group = '" + dr["F_Group"].ToString() + "'"); MessageBox.Show(this, "数据保存成功!", "提示"); DataBind(); return(true); } else { return(false); } }
private void Save(object sender, EventArgs e) { viewField.CloseEditor(); viewField.UpdateCurrentRow(); DataSet ds = ((DataTable)gridField.DataSource).DataSet; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr["F_FieldText"] == DBNull.Value) { MessageBox.Show("字段标识不能为空", "提示"); return; } //if (dr["F_FieldName"] == DBNull.Value) //{ // MessageBox.Show("字段名称不能为空","提示"); // return; //} //if (dr["F_Type"] == DBNull.Value) //{ // MessageBox.Show("字段类型不能为空", "提示"); // return; //} //dr["F_Module"] = tvTable.SelectedNode.Parent.Text; //dr["F_TableText"] = tvTable.SelectedNode.Text; //dr["F_TableName"] = tvTable.SelectedNode.Tag.ToString(); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_SysField") >= 0) { MessageBox.Show("数据保存成功!", "提示"); ds.AcceptChanges(); } }
/// <summary> /// 保存数据 /// </summary> protected virtual bool Save() { binData.EndEdit(); if (SavePre() == false) { return(false); } DataSet ds = ((DataView)binData.DataSource).Table.DataSet; DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, strSaveSlaverSQL) == 0) { ds.AcceptChanges(); return(true); } else { return(false); } }
/// <summary> /// 保存数据 /// </summary> private bool Save() { if (Convert.ToDecimal(spinControl3.GetValue()) == 0 && Convert.ToDecimal(spinControl4.GetValue()) == 0) { MessageBox.Show(this, "借方金额与贷方金额不能同时为零!", "提示"); return(false); } DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsSave = ((DataTable)binEdit.DataSource).DataSet; if (myHelper.SaveData(dsSave, "select * from t_BankAccount where F_Date = '" + dtDate.ToString() + "' and F_DayOrder = " + decID.ToString()) == 0) { dsSave.AcceptChanges(); return(true); } else { return(false); } }
private void SaveColumnInfo() { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_Dict"); int iCnt = Grid.Rows.Count; for (int i = 0; i < iCnt; i++) { if (Convert.ToBoolean(Grid.Rows[i].Cells["F_Visible"].Value) == false) { continue; } DataRow[] dr = ds.Tables[0].Select("F_Name = '" + Grid.Rows[i].Cells["F_ColumnName"].Value.ToString() + "'"); if (dr.Length == 0) { DataRow drNew = ds.Tables[0].NewRow(); drNew["F_Name"] = Grid.Rows[i].Cells["F_ColumnName"].Value.ToString(); drNew["F_Caption"] = Grid.Rows[i].Cells["F_ColumnCaption"].Value.ToString(); ds.Tables[0].Rows.Add(drNew); } } myHelper.SaveData(ds, "select * from t_Dict"); }
/// <summary> /// 导入数据子方法 /// </summary> /// <param name="strSQL"></param> /// <param name="strFile"></param> /// <returns></returns> private int Import(string strSQL, string strFile) { DataSet dsTmp = new DataSet(); dsTmp.ReadXml(strPath + strFile + ".xml"); /* * foreach (DataRow dr in dsTmp.Tables[0].Rows) * { * foreach (DataColumn dc in dsTmp.Tables[0].Columns) * { * if (dc.DataType == System.Type.GetType("System.DateTime")) * { * if (dr[dc].ToString().Substring(0, 4) == "0001") * { * dr[dc] = Convert.ToDateTime("1900-1-1"); * } * } * } * } */ try { DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet dsNew = myHelper.GetDs(strSQL); foreach (DataRow dr in dsTmp.Tables[0].Rows) { DataRow drNew = dsNew.Tables[0].NewRow(); foreach (DataColumn dc in dsTmp.Tables[0].Columns) { if (dc.DataType == System.Type.GetType("System.DateTime")) { if (dr[dc].ToString().Substring(0, 4) == "0001") { //dr[dc] = Convert.ToDateTime("1900-1-1"); drNew[dc.ColumnName] = Convert.ToDateTime("1900-1-1"); } else { drNew[dc.ColumnName] = dr[dc]; } } else { drNew[dc.ColumnName] = dr[dc]; } } dsNew.Tables[0].Rows.Add(drNew); } myHelper.SaveData(dsNew, strSQL); dsTmp.Dispose(); progressBar.Value = progressBar.Value + 1; return(1); } catch (Exception E) { MessageBox.Show(this, E.Message, strFile); return(-1); } }
/// <summary> /// 保存字段格式 /// </summary> private void SaveFieldFormat() { string strSumType = ""; DataRow drColumn; bool blnFlag = false, blnTag = false; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + BillTag + "' and F_Tag = '" + cbType.SelectedIndex.ToString() + "' order by F_Order"); if (ds.Tables[0].Rows.Count == 0) { blnTag = false; } else { blnTag = true; } foreach (GridColumn gc in gvList.Columns) { string strField = gc.FieldName; string strCapiton = gc.Caption; int intWith = gc.Width; bool blnVisible = gc.Visible; if (blnTag == false) { drColumn = ds.Tables[0].NewRow(); blnFlag = true; } else { DataRow[] dr = ds.Tables[0].Select("F_Field = '" + strField + "'"); drColumn = dr[0]; } drColumn["F_Class"] = BillTag; drColumn["F_Tag"] = cbType.SelectedIndex; drColumn["F_Field"] = gc.FieldName; drColumn["F_Caption"] = strCapiton; drColumn["F_Width"] = intWith; drColumn["F_Visible"] = blnVisible; drColumn["F_Edit"] = 0; drColumn["F_Format"] = gc.DisplayFormat.FormatString; drColumn["F_FootFormat"] = gc.SummaryItem.DisplayFormat; drColumn["F_FieldType"] = gc.ColumnType.ToString(); drColumn["F_Order"] = gc.VisibleIndex; if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { drColumn["F_Merge"] = true; } else { drColumn["F_Merge"] = false; } strSumType = ""; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_SumType"] = strSumType; GridGroupSummaryItem Gi = GetGroupType(strField); if (Gi != null) { strSumType = ""; switch (Gi.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_GroupType"] = strSumType; drColumn["F_GroupFormat"] = Gi.DisplayFormat; } if (blnFlag == false) { drColumn.EndEdit(); } else { ds.Tables[0].Rows.Add(drColumn); } } myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + BillTag + "' and F_Tag = '" + cbType.SelectedIndex.ToString() + "'"); }
/// <summary> /// 保存数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void sbOK_Click(object sender, EventArgs e) { string strSQL = "select * from t_Parm"; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs(strSQL); DataRow dr = ds.Tables[0].Rows[0]; dr.BeginEdit(); dr["F_N1"] = checkBox1.Checked; dr["F_N2"] = checkBox2.Checked; dr["F_N3"] = checkBox3.Checked; dr["F_N8"] = checkBox4.Checked; dr["F_N9"] = checkBox5.Checked; dr["F_N10"] = checkBox6.Checked; dr["F_N11"] = checkBox7.Checked; dr["F_N12"] = checkBox8.Checked; dr["F_N13"] = checkBox10.Checked; dr["F_N14"] = checkBox11.Checked; dr["F_N15"] = checkBox12.Checked; dr["F_NeedPrice"] = checkBox9.Checked; dr["F_C1"] = cbDate.SelectedIndex; dr["F_Debit1"] = textEdit1.Text; dr["F_Credit1"] = textEdit2.Text; dr["F_Debit2"] = textEdit4.Text; dr["F_Credit2"] = textEdit3.Text; dr["F_Debit3"] = textEdit6.Text; dr["F_Credit3"] = textEdit5.Text; dr["F_Debit4"] = textEdit8.Text; dr["F_Credit4"] = textEdit7.Text; dr["F_Debit5"] = textEdit10.Text; dr["F_Credit6"] = textEdit9.Text; dr["F_Debit6"] = textEdit12.Text; dr["F_Credit6"] = textEdit11.Text; dr["F_Debit7"] = textEdit14.Text; dr["F_Credit7"] = textEdit13.Text; dr["F_Type1"] = comboBoxEdit1.Text; dr["F_Type2"] = comboBoxEdit2.Text; dr["F_Type3"] = comboBoxEdit3.Text; dr["F_C2"] = spinEdit1.Value; dr["F_C3"] = spinEdit2.Value; dr["F_C4"] = spinEdit3.Value; dr["F_C5"] = spinEdit4.Value; dr["F_C6"] = spinEdit5.Value; dr["F_C7"] = spinEdit6.Value; dr["F_OAAdr"] = textEdit15.Text; //采购 dr["F_N16"] = checkBox13.Checked; dr["F_N17"] = checkBox14.Checked; dr["F_N18"] = checkBox15.Checked; dr["F_N19"] = checkBox16.Checked; dr["F_N20"] = checkBox17.Checked; //销售 dr["F_N21"] = checkBox18.Checked; dr["F_N22"] = checkBox19.Checked; dr["F_N23"] = checkBox20.Checked; dr["F_N24"] = checkBox21.Checked; dr["F_N25"] = checkBox22.Checked; dr["F_N26"] = checkBox23.Checked; //仓库 dr["F_N27"] = checkBox29.Checked; dr["F_N28"] = checkBox28.Checked; dr["F_N29"] = checkBox27.Checked; dr["F_N30"] = checkBox26.Checked; //生产 dr["F_N31"] = checkBox31.Checked; dr["F_N32"] = checkBox30.Checked; dr["F_N33"] = checkBox25.Checked; dr["F_N34"] = checkBox24.Checked; dr["F_N35"] = checkBox32.Checked; dr["F_N36"] = checkBox33.Checked; dr["F_N37"] = checkBox34.Checked; //委外 dr["F_N38"] = checkBox41.Checked; dr["F_N39"] = checkBox40.Checked; dr["F_N40"] = checkBox39.Checked; dr["F_N41"] = checkBox38.Checked; dr["F_N42"] = checkBox37.Checked; dr["F_N43"] = checkBox36.Checked; dr["F_N44"] = checkBox35.Checked; dr.EndEdit(); if (myHelper.SaveData(ds, strSQL) == 0) { this.DialogResult = DialogResult.OK; } }
/// <summary> /// 保存字段格式 /// </summary> protected virtual void SaveFieldFormat() { string strSumType = ""; DataRow drColumn; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + rgOption.SelectedIndex.ToString() + "'"); foreach (GridColumn gc in gvReport.Columns) { string strField = gc.FieldName; string strCapiton = gc.Caption; int intWith = gc.Width; bool blnVisible = gc.Visible; drColumn = ds.Tables[0].NewRow(); drColumn["F_Class"] = ReportTag; drColumn["F_Tag"] = rgOption.SelectedIndex; drColumn["F_Field"] = gc.FieldName; drColumn["F_Caption"] = strCapiton; drColumn["F_Width"] = intWith; drColumn["F_Visible"] = blnVisible; drColumn["F_Edit"] = 0; drColumn["F_Format"] = gc.DisplayFormat.FormatString; drColumn["F_FootFormat"] = gc.SummaryItem.DisplayFormat; drColumn["F_Order"] = gc.VisibleIndex; if (gc.OptionsColumn.AllowMerge == DevExpress.Utils.DefaultBoolean.True) { drColumn["F_Merge"] = true; } else { drColumn["F_Merge"] = false; } strSumType = ""; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_SumType"] = strSumType; GridGroupSummaryItem Gi = GetGroupType(strField); if (Gi != null) { strSumType = ""; switch (Gi.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_GroupType"] = strSumType; drColumn["F_GroupFormat"] = Gi.DisplayFormat; } ds.Tables[0].Rows.Add(drColumn); } myHelper.ExecuteSQL("delete from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + rgOption.SelectedIndex.ToString() + "'"); myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + ReportTag + "' and F_Tag = '" + rgOption.SelectedIndex.ToString() + "'"); }
/// <summary> /// 保存字段格式 /// </summary> private void SaveFieldFormat() { string strSumType = ""; DataRow drColumn; bool blnFlag = false, blnTag = false; DataLib.DataHelper myHelper = new DataLib.DataHelper(); DataSet ds = myHelper.GetDs("select * from t_ReportField where F_Class = '" + BillTag + "' and F_Tag = '0' order by F_Order"); if (ds.Tables[0].Rows.Count == 0) { blnTag = false; } else { blnTag = true; } foreach (GridColumn gc in gvMain.Columns) { string strField = gc.FieldName; string strCapiton = gc.Caption; int intWith = gc.Width; bool blnVisible = gc.Visible; if (blnTag == false) { drColumn = ds.Tables[0].NewRow(); blnFlag = true; } else { DataRow[] dr = ds.Tables[0].Select("F_Field = '" + strField + "'"); drColumn = dr[0]; } drColumn["F_Class"] = BillTag; drColumn["F_Tag"] = "0"; drColumn["F_Field"] = gc.FieldName; drColumn["F_Caption"] = strCapiton; drColumn["F_Width"] = intWith; drColumn["F_Visible"] = blnVisible; drColumn["F_Edit"] = 0; drColumn["F_Format"] = ""; drColumn["F_FootFormat"] = ""; drColumn["F_Order"] = gc.VisibleIndex; strSumType = ""; switch (gc.SummaryItem.SummaryType) { case DevExpress.Data.SummaryItemType.Sum: strSumType = "sum"; break; case DevExpress.Data.SummaryItemType.Average: strSumType = "avg"; break; case DevExpress.Data.SummaryItemType.Count: strSumType = "count"; break; case DevExpress.Data.SummaryItemType.Max: strSumType = "max"; break; case DevExpress.Data.SummaryItemType.Min: strSumType = "min"; break; } drColumn["F_SumType"] = strSumType; if (blnFlag == false) { drColumn.EndEdit(); } else { ds.Tables[0].Rows.Add(drColumn); } } myHelper.SaveData(ds, "select * from t_ReportField where F_Class = '" + BillTag + "' and F_Tag = '0'"); }
protected override void Edit() { //if (gvBase.FocusedRowHandle < 0) return; //base.Edit(); gvBase.PostEditor(); DataSet ds = ((DataView)gcBase.DataSource).Table.DataSet; //ds.AcceptChanges(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["F_EvaBeginDate"] == DBNull.Value) { MessageBox.Show(this, "有效开始日期不能为空!!", "提示"); return; } if (dr["F_EvaEndDate"] == DBNull.Value) { MessageBox.Show(this, "有效结束日期不能为空!!", "提示"); return; } if (dr["F_SupplierID"] == DBNull.Value) { MessageBox.Show(this, "供应商不能为空!!", "提示"); return; } if (dr["F_ItemID"] == DBNull.Value) { MessageBox.Show(this, "物料不能为空!!", "提示"); return; } if (dr["F_QtyMin"] == DBNull.Value) { MessageBox.Show(this, "开始数量不能为空!!", "提示"); return; } if (dr["F_QtyMax"] == DBNull.Value) { MessageBox.Show(this, "结束数量不能为空!!", "提示"); return; } if (Convert.ToDecimal(dr["F_QtyMin"]) < Convert.ToDecimal(dr["F_QtyMin"])) { MessageBox.Show(this, "开始数量不能大于结束数量!!", "提示"); return; } } DataLib.DataHelper myHelper = new DataLib.DataHelper(); if (myHelper.SaveData(ds, "select * from t_PriceStock") == 0) { MessageBox.Show(this, "数据保存成功!!", "提示"); ds.AcceptChanges(); } }