/// <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();
}
}
