private void cbBill_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbBill.Text.Length == 0)
{
return;
}
DataRow[] dr = dsTmp.Tables[0].Select("F_Class = '" + cbBill.Text + "'");
if (dr.Length == 0)
{
return;
}
strMasterSQL = dr[0]["F_MasterSQL"].ToString();
strSlaverSQL = dr[0]["F_SlaverSQL"].ToString();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
if (strMasterSQL.Length > 0)
{
DataSet dsMaster;
if (strValue == "")
{
dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm2());
}
else
{
dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm3());
}
gcMaster.DataSource = dsMaster.Tables[0].DefaultView;
}
}
/// <summary>
/// 数据绑定
/// </summary>
protected virtual int BindData()
{
if (strQuerySQL.Length == 0)
{
return(-1);
}
BaseClass.frmFlag myFlag = new BaseClass.frmFlag();
myFlag.Show();
myFlag.Update();
try
{
try
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds;
if (cbCutOff.Visible == false)
{
ds = myHelper.GetOtherDs(strQuerySQL, GetParm3());
}
else
{
ds = myHelper.GetOtherDs(strQuerySQL, GetParm5());
}
if (ds == null)
{
return(-1);
}
int intRow = gvList.FocusedRowHandle;
gcList.DataSource = ds.Tables[0].DefaultView;
if (intRow <= gvList.RowCount)
{
gvList.FocusedRowHandle = intRow;
}
//AssignField();
DataLib.sysClass.LoadFormatFromDB(gvList, BillTag, cbType.SelectedIndex);
DataLib.SysVar.TestColumnRight(gvList, this.Name);
return(0);
}
catch (Exception E)
{
MessageBox.Show(E.Message, "错误");
return(-1);
}
}
finally
{
myFlag.Dispose();
}
}
/// <summary>
/// 数据绑定
/// </summary>
protected virtual int BindData()
{
if (strQuerySQL.Length == 0)
{
return(-1);
}
BaseClass.frmFlag myFlag = new BaseClass.frmFlag();
myFlag.Show();
myFlag.Update();
try
{
try
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds;
if (rgOption.Visible == false)
{
ds = myHelper.GetOtherDs(strQuerySQL, GetParm());
}
else
{
ds = myHelper.GetOtherDs(strQuerySQL, GetParm1());
}
if (ds == null)
{
return(-1);
}
//gvReport.Columns.Clear();
gcReport.DataSource = ds.Tables[0].DefaultView;
//AssignField();
DataLib.sysClass.LoadFormatFromDB(gvReport, ReportTag, rgOption.SelectedIndex);
DataLib.SysVar.TestColumnRight(gvReport, this.Name);
return(0);
}
catch (Exception E)
{
MessageBox.Show(E.Message, "错误");
return(-1);
}
}
finally
{
myFlag.Dispose();
}
}
private void DataBind()
{
string strSQL = "";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
strSQL = "select isnull(F_QcMoney,0) - isnull(F_QCHasMoney,0) as F_Money from t_Supplier where F_ID = '" + strValue + "'";
DataSet ds = myHelper.GetDs(strSQL);
if (Convert.ToDecimal(ds.Tables[0].Rows[0]["F_Money"]) > 0)
{
strSQL = "select '期初' as F_Tag,'期初' as F_BillID,'1900-1-1' as F_Date,F_QcMoney as F_TotalMoney,F_QCHasMoney as F_PayMoney,";
strSQL = strSQL + "isnull(F_QcMoney,0) - isnull(F_QCHasMoney,0) as F_NoPay,Cast(0 as Bit) as F_Select from t_Supplier where F_ID = @Value and isnull(F_QcMoney,0) - isnull(F_QCHasMoney,0) > 0";
strSQL = strSQL + " union all ";
}
else
{
strSQL = "";
}
strSQL = strSQL + "select '采购进货' as F_Tag,F_BillID,F_Date,isnull(F_Money,0)+isnull(F_OtherMoney,0) as F_TotalMoney,";
strSQL = strSQL + "F_PayMoney,isnull(F_Money,0)+isnull(F_OtherMoney,0) - isnull(F_PayMoney,0) as F_NoPay,";
strSQL = strSQL + "Cast(0 as Bit) as F_Select ";
strSQL = strSQL + "from t_StockIn where F_Check = 1 and isnull(F_Money,0)+isnull(F_OtherMoney,0) - isnull(F_PayMoney,0) <> 0 ";
strSQL = strSQL + "and F_PayDate >= @Start and F_PayDate <= @End and F_SupplierID = @Value";
strSQL = strSQL + " union all ";
strSQL = strSQL + "select '采购退货',F_BillID,F_Date,isnull(F_Money,0)+isnull(F_OtherMoney,0),";
strSQL = strSQL + "F_PayMoney,isnull(F_Money,0)+isnull(F_OtherMoney,0) - isnull(F_PayMoney,0),";
strSQL = strSQL + "Cast(0 as Bit) as F_Select ";
strSQL = strSQL + "from t_StockBack where F_Check = 1 and isnull(F_Money,0)+isnull(F_OtherMoney,0) - isnull(F_PayMoney,0) <> 0 ";
strSQL = strSQL + "and F_PayDate >= @Start and F_PayDate <= @End and F_SupplierID = @Value";
strSQL = strSQL + " and F_Kind = '退款转应付款'";
ds = myHelper.GetOtherDs(strSQL, GetParm3());
gcMain.DataSource = ds.Tables[0].DefaultView;
}
private DataSet GetQuery()
{
DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle);
string sSQL = "select isnull(F_SQL,'') as F_SQL from t_ReportFormat where F_FormName = '" + sFormName + "' and F_ReportName = '" + dr["F_ReportName"].ToString() + "'";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetDs(sSQL);
string sPrintSQL = "";
if (ds.Tables[0].Rows.Count > 0)
{
sPrintSQL = ds.Tables[0].Rows[0][0].ToString();
}
if (sPrintSQL == "")
{
MessageBox.Show(this, "选定报表还没设置相应的SQL语句,请先设置!", "提示");
return(null);
}
Hashtable htParm = new Hashtable();
htParm.Add("@Value", sBillID);
DataSet dsResult = myHelper.GetOtherDs(sPrintSQL, htParm);
return(dsResult);
}
/// <summary>
/// 数据绑定
/// </summary>
protected virtual void BindData()
{
if (strQuerySQL.Length == 0)
{
return;
}
BaseClass.frmFlag myFlag = new BaseClass.frmFlag();
myFlag.Show();
myFlag.Update();
try
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetOtherDs(strQuerySQL, GetParm());
if (ds == null)
{
return;
}
int intRow = gvBase.FocusedRowHandle;
gcBase.DataSource = ds.Tables[0].DefaultView;
DataLib.SysVar.TestColumnRight(gvBase, this.Name);
if (intRow <= gvBase.RowCount)
{
gvBase.FocusedRowHandle = intRow;
}
}
finally
{
myFlag.Dispose();
}
}
/// <summary>
/// 刷新相关单据
/// </summary>
private void RefreshSlaver()
{
if (strSlaverSQL.Length > 0)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsSlaver = myHelper.GetOtherDs(strSlaverSQL, GetParm());
gcSlaver.DataSource = dsSlaver.Tables[0].DefaultView;
}
}
private DataSet GetQuery(string sSQL)
{
Hashtable htParm = new Hashtable();
htParm.Add("@Value", sBillID);
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetOtherDs(sSQL, htParm);
return(ds);
}
/// <summary>
/// 刷新相关单据
/// </summary>
private void RefreshSlaver()
{
if (strSlaverSQL.Length > 0)
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsSlaver;
if (blnFlag == false)
{
dsSlaver = myHelper.GetOtherDs(strSlaverSQL, GetParm());
}
else
{
dsSlaver = myHelper.GetOtherDs(strSlaverSQL, GetParmOther());
}
gvSlaver.Columns.Clear();
gcSlaver.DataSource = dsSlaver.Tables[0].DefaultView;
DataLib.sysClass.LoadFormatFromDB(gvSlaver, BillTag, 1);
}
}
private int DataBind()
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetOtherDs(strQuerySQL, GetParm());
if (ds == null)
{
return(-1);
}
gcReport.DataSource = ds.Tables[0].DefaultView;
AssignField();
return(0);
}
private void DataBind()
{
string strSQL = "select F_BillID,F_Date,isnull(F_Money,0) as F_TotalMoney,";
strSQL = strSQL + "F_PayMoney,isnull(F_Money,0) - isnull(F_PayMoney,0) as F_NoPay,";
strSQL = strSQL + "Cast(0 as Bit) as F_Select ";
strSQL = strSQL + "from t_OutBill where isnull(F_Money,0) - isnull(F_PayMoney,0) <> 0 ";
strSQL = strSQL + "and F_Date >= @Start and F_Date <= @End and F_OutSupplierID = @Value";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds = myHelper.GetOtherDs(strSQL, GetParm3());
gcMain.DataSource = ds.Tables[0].DefaultView;
}
protected override int BindData()
{
if (edSubject.GetValue() == null)
{
return(-1);
}
if (strQuerySQL.Length == 0)
{
return(-1);
}
BaseClass.frmFlag myFlag = new BaseClass.frmFlag();
myFlag.Show();
myFlag.Update();
try
{
try
{
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet ds;
ds = myHelper.GetOtherDs(strQuerySQL, GetParm());
if (ds == null)
{
return(-1);
}
gvReport.Columns.Clear();
gcReport.DataSource = ds.Tables[0].DefaultView;
gvReport.Columns["F_Date"].Caption = "ÈÕÆÚ";
gvReport.Columns["F_Key"].Caption = "ƾ֤×Ö";
gvReport.Columns["F_Tag"].Caption = "ÕªÒª";
gvReport.Columns["F_Money"].Caption = "ºÏ¼Æ";
//gvReport.Columns["F_Rest"].Caption = "Óà¶î";
//AssignField();
return(0);
}
catch (Exception E)
{
MessageBox.Show(E.Message, "´íÎó");
return(-1);
}
}
finally
{
myFlag.Dispose();
}
}
public override void BindData()
{
base.BindData();
string strSQL = "";
strSQL = "select a.*,b.F_Name as F_ItemName,b.F_Spec,b.F_Material,b.F_Brand,(select F_Name from t_Class where F_ID = b.F_Type) as F_Type ";
strSQL = strSQL + "from t_OutBillItem a,t_Item b ";
strSQL = strSQL + "where a.F_ItemID = b.F_ID ";
strSQL = strSQL + "and F_BillID = @Value";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsItem = myHelper.GetOtherDs(strSQL, GetParm());
dsItem.Tables[0].TableNewRow += new DataTableNewRowEventHandler(ItemSlaverNewRow);
binItem.DataSource = dsItem.Tables[0].DefaultView;
gcItem.DataSource = binItem;
gvItem.OptionsBehavior.Editable = gvList.OptionsBehavior.Editable;
}
/// <summary>
/// 保存部门
/// </summary>
private DataSet SaveDept(DataSet dsMaster, DataSet dsSlaver, DataSet dsUpdateSlaver, ref string strDeptSQL)
{
gvDept.PostEditor();
binDept.EndEdit();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
strDeptSQL = "select * from t_TaskDept where F_BillID = @Value";
DataSet dsUpdateDept = myHelper.GetOtherDs(strDeptSQL, GetParm());
foreach (DataRow dr in dsUpdateDept.Tables[0].Rows)
{
dr.Delete();
}
DataSet dsDept = ((DataView)binDept.DataSource).Table.DataSet;
DataTable dt = dsDept.Tables[0];
dt.AcceptChanges();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = dsUpdateDept.Tables[0].NewRow();
int intCnt = dt.Columns.Count;
for (int i = 0; i < intCnt; i++)
{
if (dt.Columns[i].ColumnName == "F_BillID")
{
drNew["F_BillID"] = dsMaster.Tables[0].Rows[0]["F_BillID"].ToString();
}
else
{
if (dsUpdateDept.Tables[0].Columns.IndexOf(dt.Columns[i].ColumnName) > 0)
{
drNew[dt.Columns[i].ColumnName] = dr[dt.Columns[i].ColumnName];
}
}
}
dsUpdateDept.Tables[0].Rows.Add(drNew);
}
return(dsUpdateDept);
}
public override void BindData()
{
base.BindData();
lbDept.DataBindings.Clear();
lbDept.DataBindings.Add("Text", binMaster, "F_Dept");
string strSQL = "";
strSQL = "select * from t_TaskDept where F_BillID = @Value";
DataLib.DataHelper myHelper = new DataLib.DataHelper();
DataSet dsDept = myHelper.GetOtherDs(strSQL, GetParm());
dsDept.Tables[0].TableNewRow += new DataTableNewRowEventHandler(ItemDeptNewRow);
dsDept.Tables[0].RowDeleted += new DataRowChangeEventHandler(ItemDeptDelRow);
binDept.DataSource = dsDept.Tables[0].DefaultView;
strSQL = "select a.*,b.F_Name as F_ItemName,b.F_Spec ";
strSQL = strSQL + "from t_TaskHalf a,t_Item b ";
strSQL = strSQL + "where a.F_ItemID = b.F_ID ";
strSQL = strSQL + "and F_BillID = @Value";
DataSet dsHalf = myHelper.GetOtherDs(strSQL, GetParm());
dsHalf.Tables[0].TableNewRow += new DataTableNewRowEventHandler(ItemSlaverNewRow1);
binHalf.DataSource = dsHalf.Tables[0].DefaultView;
//DataLib.sysClass.LoadFormatFromDB(gvHalf, this.Name, 1);
//this.AssignField("1",gvHalf);
/*
* ds.Tables[0].TableNewRow += new DataTableNewRowEventHandler(SlaverNewRow);
* ds.Tables[0].ColumnChanging += new DataColumnChangeEventHandler(ColumnChanging);
* ds.Tables[0].ColumnChanged += new DataColumnChangeEventHandler(ColumnChanged);
*/
strSQL = "select a.*,b.F_Name as F_ItemName,b.F_Spec ";
strSQL = strSQL + "from t_TaskItem a,t_Item b ";
strSQL = strSQL + "where a.F_ItemID = b.F_ID ";
strSQL = strSQL + "and F_BillID = @Value";
DataSet dsItem = myHelper.GetOtherDs(strSQL, GetParm());
binItem.DataSource = dsItem.Tables[0].DefaultView;
dsItem.Tables[0].TableNewRow += new DataTableNewRowEventHandler(ItemSlaverNewRow2);
//DataLib.sysClass.LoadFormatFromDB(gvItem, this.Name, 2);
//this.AssignField("2",gvItem);
/*
* ds.Tables[0].TableNewRow += new DataTableNewRowEventHandler(SlaverNewRow);
* ds.Tables[0].ColumnChanging += new DataColumnChangeEventHandler(ColumnChanging);
* ds.Tables[0].ColumnChanged += new DataColumnChangeEventHandler(ColumnChanged);
*/
DataSet dsDropDept = myHelper.GetDs("select F_ID,F_Name from t_Class where F_ID like '03.%'");
this.lupDept.DataSource = dsDropDept.Tables[0].DefaultView;
this.lupDept.DisplayMember = "F_Name";
this.lupDept.ValueMember = "F_ID";
FocusedRowChanged(null, null);
}
private void cbBill_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbBill.Text.Length == 0)
{
return;
}
BillTag = strBillType + cbBill.Text;
DataRow[] dr = dsTmp.Tables[0].Select("F_Class = '" + cbBill.Text + "'");
if (dr.Length == 0)
{
return;
}
strMasterSQL = dr[0]["F_MasterSQL"].ToString();
strSlaverSQL = dr[0]["F_SlaverSQL"].ToString();
DataLib.DataHelper myHelper = new DataLib.DataHelper();
if (strMasterSQL.Length > 0)
{
DataSet dsMaster;
if (strValue != "")
{
dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm3());
}
else
{
if (blnFlag == true)
{
dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm2());
}
else
{
dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm3());
}
}
//if ( blnFlag == false)
// dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm2());
//else
//{
// if (blnFlag == true)
// dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm2());
// else
// dsMaster = myHelper.GetOtherDs(strMasterSQL, GetParm3());
//}
gvMaster.Columns.Clear();
gcMaster.DataSource = dsMaster.Tables[0].DefaultView;
//if (dsMaster.Tables[0].Rows.Count > 0)
//{
RefreshSlaver();
//}
DataLib.sysClass.LoadFormatFromDB(gvMaster, BillTag, 0);
DataLib.sysClass.LoadFormatFromDB(gvSlaver, BillTag, 1);
DataTable dtSlaver = ((DataView)gcSlaver.DataSource).Table;
if (dtSlaver.Columns.Contains("F_Select") == true)
{
gvSlaver.Columns["F_Select"].OptionsColumn.AllowFocus = true;
gvSlaver.Columns["F_Select"].OptionsColumn.AllowEdit = true;
}
//AssignField();
//AssignField1();
}
}
protected override bool Save(DataSet dsMaster, DataSet dsSlaver, DataSet dsUpdateSlaver)
{
//return base.Save(dsMaster, dsSlaver, dsUpdateSlaver);
DataLib.DataHelper myHelper = new DataLib.DataHelper();
string strItemSQL = "select * from t_OutBillItem where F_BillID = @Value";
DataSet dsUpdateItem = myHelper.GetOtherDs(strItemSQL, GetParm());
foreach (DataRow dr in dsUpdateItem.Tables[0].Rows)
{
dr.Delete();
}
DataSet dsItem = ((DataView)binItem.DataSource).Table.DataSet;
DataTable dt = dsItem.Tables[0];
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = dsUpdateItem.Tables[0].NewRow();
int intCnt = dt.Columns.Count;
for (int i = 0; i < intCnt; i++)
{
if (dt.Columns[i].ColumnName == "F_BillID")
{
drNew["F_BillID"] = dsMaster.Tables[0].Rows[0]["F_BillID"].ToString();
}
else
{
if (dsUpdateItem.Tables[0].Columns.IndexOf(dt.Columns[i].ColumnName) > 0)
{
drNew[dt.Columns[i].ColumnName] = dr[dt.Columns[i].ColumnName];
}
}
}
dsUpdateItem.Tables[0].Rows.Add(drNew);
}
DataSet[] dsData = new DataSet[3];
dsData[0] = dsMaster;
dsData[1] = dsUpdateSlaver;
dsData[2] = dsUpdateItem;
string[] strSQL = new string[3];
strSQL[0] = strMasterSQL;
strSQL[1] = strSaveSlaverSQL;
strSQL[2] = strItemSQL;
if (myHelper.SaveMuteData1(dsData, strSQL, GetParm()).Length == 0)
{
MessageBox.Show("数据保存成功!!", "提示");
strBillID = editControl1.GetValue().ToString();
dsMaster.AcceptChanges();
dsSlaver.AcceptChanges();
dsItem.AcceptChanges();
SetStatus(2);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 保存
/// </summary>
private bool SaveBill()
{
int intCnt = 0;
gvMain.UpdateSummary();
if (SavePre() == false)
{
return(false);
}
DataLib.DataHelper myHelper = new DataLib.DataHelper();
binSlaver.EndEdit();
binMaster.EndEdit();
DataSet dsMaster = ((DataView)binMaster.DataSource).Table.DataSet;
DataSet dsSlaver = ((DataView)binSlaver.DataSource).Table.DataSet;
if (decID == 0)
{
decID = GetMaxID();
dsMaster.Tables[0].Rows[0].BeginEdit();
dsMaster.Tables[0].Rows[0]["F_ID"] = decID;
dsMaster.Tables[0].Rows[0].EndEdit();
}
binSlaver.EndEdit();
binMaster.EndEdit();
DataSet dsUpdateSlaver = myHelper.GetOtherDs(strSaveSlaverSQL, GetParm());
foreach (DataRow dr in dsUpdateSlaver.Tables[0].Rows)
{
dr.Delete();
}
DataTable dt = dsSlaver.Tables[0];
dt.AcceptChanges();
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState == DataRowState.Deleted)
{
continue;
}
string sID = dr["F_Subject"] == DBNull.Value ? "" :dr["F_Subject"].ToString();
if (sID == "")
{
continue;
}
DataRow drNew = dsUpdateSlaver.Tables[0].NewRow();
intCnt = dt.Columns.Count;
for (int i = 0; i < intCnt; i++)
{
if (dt.Columns[i].ColumnName == "F_ID")
{
drNew["F_ID"] = dsMaster.Tables[0].Rows[0]["F_ID"];
}
else
{
if (dsUpdateSlaver.Tables[0].Columns.IndexOf(dt.Columns[i].ColumnName) > 0)
{
drNew[dt.Columns[i].ColumnName] = dr[dt.Columns[i].ColumnName];
}
}
}
dsUpdateSlaver.Tables[0].Rows.Add(drNew);
}
return(Save(dsMaster, dsSlaver, dsUpdateSlaver));
}
