private void LoadBaseItem()
{
string sErr = "";
string sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 0 ";
DataSet set = null;
set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "MatType", 0, 0, "", out sErr);
if ((sErr.Trim() != "0") && (sErr.Trim() != ""))
{
MessageBox.Show(sErr);
}
if (set != null)
{
DataTable table = set.Tables["MatType"];
this.cmb_cTypeId1.DisplayMember = "cTypeName";
this.cmb_cTypeId1.ValueMember = "cTypeId";
this.cmb_cTypeId1.DataSource = table;
table.Clear();
}
set.Clear();
sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 1 ";
set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, "ACNTType", 0, 0, "", out sErr);
if ((sErr.Trim() != "0") && (sErr.Trim() != ""))
{
MessageBox.Show(sErr);
}
if (set != null)
{
set.Tables["ACNTType"].Clear();
}
set.Clear();
}
private void btn_Qry_Click(object sender, EventArgs e)
{
string sErr = "";
string sSql = GetSql();
DataSet dsX = null;
Cursor.Current = Cursors.WaitCursor;
try
{
dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "IOStoreDtl", 0, 0, "", out sErr);
Cursor.Current = Cursors.Default;
}
catch (Exception err)
{
Cursor.Current = Cursors.Default;
MessageBox.Show(err.Message);
return;
}
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
return;
}
if (dsX != null)
{
DataTable tbX = dsX.Tables["IOStoreDtl"];
bds_Data.DataSource = tbX.Copy();
dsX.Clear();
}
}
private void btn_Qry_Click(object sender, EventArgs e)
{
string sErr = "";
string sql = this.GetSql();
DataSet set = null;
Cursor.Current = Cursors.WaitCursor;
try
{
set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sql, "IOStoreDtl", 0, 0, "", out sErr);
Cursor.Current = Cursors.Default;
}
catch (Exception exception)
{
Cursor.Current = Cursors.Default;
MessageBox.Show(exception.Message);
return;
}
if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
{
MessageBox.Show(sErr);
}
else if (set != null)
{
this.bds_Data.DataSource = set.Tables["IOStoreDtl"].Copy();
set.Clear();
}
}
private void btn_Qry_Click(object sender, EventArgs e)
{
string sErr = "";
StringBuilder builder = new StringBuilder("");
builder.Append("select mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark,");
builder.Append("mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,isnull(mat.cABC,'C') cABC,");
builder.Append("mt.cTypeName cType1,atp.cTypeName cType2,sum(isnull(st.fQty,0)) fQty,mat.nKeepDay,isnull(st.cDtlSupplier,' ') cSupplier,isnull(st.cDtlCSId,' ') cCSId,isnull(mat.nMatClass,0) nMatClass,isnull(isnull(st.cDtlRemark,st.cStoreRemark),' ') cDtlRemark ");
builder.Append("\tfrom TPC_Material mat ");
builder.Append(" left join V_MaterialMatType mt on mat.cTypeId1=mt.cTypeId ");
builder.Append(" left join V_MaterialAcntType atp on mat.cTypeId2=atp.cTypeId ");
builder.Append(" left join V_StoreItemList st on mat.cMNo=st.cMNo ");
builder.Append(" where 1=1 ");
builder.Append(this.GetCondition());
builder.Append(" group by mat.cMNo,mat.cName,mat.cSpec,mat.cMatStyle,mat.cMatQCLevel,mat.cMatOther,mat.cRemark, ");
builder.Append(" mat.fQtyBox,mat.fSafeQtyDn,mat.fSafeQtyUp,mat.fWeight,mat.cUnit,mat.cTypeId1,mat.cTypeId2,mt.cTypeName,");
builder.Append(" atp.cTypeName,mat.cABC,mat.nKeepDay,isnull(st.cDtlSupplier,' '),isnull(st.cDtlCSId,' ') ,isnull(mat.nMatClass,0),isnull(isnull(st.cDtlRemark,st.cStoreRemark),' ')");
DataSet set = null;
Cursor.Current = Cursors.WaitCursor;
try
{
set = DBFuns.GetDataBySql(base.AppInformation.SvrSocket, false, builder.ToString(), "TPC_Material", 0, 0, "", out sErr);
Cursor.Current = Cursors.Default;
}
catch (Exception exception)
{
Cursor.Current = Cursors.Default;
MessageBox.Show(exception.Message);
return;
}
if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
{
MessageBox.Show(sErr);
}
else
{
DataTable table = set.Tables["TPC_Material"];
this.bds_Data.DataSource = table;
}
}
private void LoadBaseItem()
{
string sErr = "";
//物料属性分类
string sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 0 ";
DataSet dsX = null;
dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "MatType", 0, 0, "", out sErr);
if (sErr.Trim() != "0" && sErr.Trim() != "")
{
MessageBox.Show(sErr);
}
if (dsX != null)
{
DataTable tbX = dsX.Tables["MatType"];
cmb_cTypeId1.DisplayMember = "cTypeName";
cmb_cTypeId1.ValueMember = "cTypeId";
cmb_cTypeId1.DataSource = tbX;
tbX.Clear();
}
dsX.Clear();
sSql = "select cTypeId,cTypeName from TPC_MaterialType where cTypeMode = 1 ";
dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, sSql, "ACNTType", 0, 0, "", out sErr);
if (sErr.Trim() != "0" && sErr.Trim() != "")
{
MessageBox.Show(sErr);
}
if (dsX != null)
{
DataTable tbX = dsX.Tables["ACNTType"];
//cmb_cTypeId2.DisplayMember = "cTypeName";
//cmb_cTypeId2.ValueMember = "cTypeId";
//cmb_cTypeId2.DataSource = tbX;
tbX.Clear();
}
dsX.Clear();
}
private void btnQry_Click(object sender, EventArgs e)
{
if (dtpFind_B.Value > dtpFind_E.Value)
{
MessageBox.Show("对不起，起始时间不能大于截止时间！");
dtpFind_B.Focus();
return;
}
StringBuilder strSql = new StringBuilder("select * from V_TWB_BillMergePlt where (dCreateDate >='" + dtpFind_B.Value.ToString("yyyy-MM-dd 00:00:00") + "' and dCreateDate <='" + dtpFind_E.Value.ToString("yyyy-MM-dd 23:59:59") + "')");
#region 条件
if (cmbFindUser.Text.Trim() != "" && cmbFindUser.Text.Trim() != "全部" && cmbFindUser.SelectedValue != null)
{
strSql.Append(" and cCreator='" + cmbFindUser.SelectedValue.ToString().Trim() + "'");
}
if (txtFindBillNo.Text.Trim() != "")
{
strSql.Append(" and cBNo like '%" + txtFindBillNo.Text.Trim() + "%'");
}
if (this.cmbFindCheck.Text.Trim() != "" && cmbFindCheck.Text.Trim() != "全部" && cmbFindCheck.SelectedIndex >= 0 && cmbFindCheck.SelectedIndex <= 1)
{
strSql.Append(" and isnull(bIsChecked,0)='" + cmbFindCheck.SelectedIndex.ToString().Trim() + "'");
}
if (this.cmb_FinishedStatus.Text.Trim() != "" && cmb_FinishedStatus.Text.Trim() != "全部" && cmb_FinishedStatus.SelectedIndex >= 0 && cmb_FinishedStatus.SelectedIndex <= 1)
{
strSql.Append(" and isnull(bIsFinished,0)='" + cmb_FinishedStatus.SelectedIndex.ToString().Trim() + "'");
}
#endregion
DataSet dsX = null;
string sErr = "";
Cursor.Current = Cursors.WaitCursor;
dsX = DBFuns.GetDataBySql(AppInformation.SvrSocket, false, strSql.ToString(), strTbNameMain, 0, 0, "dCreateDate,dCheckDate", out sErr);
Cursor.Current = Cursors.Default;
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
return;
}
if (dsX == null)
{
MessageBox.Show("获取数据时失败！");
return;
}
DataTable tbData = null;
if (dsX.Tables.Count > 0)
{
if (dsX.Tables[0].Rows[0][0].ToString() == "-1")
{
MessageBox.Show(dsX.Tables[0].Rows[0][1].ToString());
return;
}
if (dsX.Tables[strTbNameMain] != null)
{
tbData = dsX.Tables[strTbNameMain].Copy();
}
if (tbData == null)
{
MessageBox.Show("获取数据时失败！");
return;
}
}
Cursor.Current = Cursors.WaitCursor;
bDSIsOpenForMain = false;
bdsMain.DataSource = tbData;
grdList.DataSource = bdsMain;
bDSIsOpenForMain = true;
lbl_M_Count.Text = bdsMain.Count.ToString();
Cursor.Current = Cursors.Default;
bdsMain_PositionChanged(null, null);
}
