private void LoadStockList(string StockId)
{
string errStr = "";
string sqlStr = "select cWHId,cName from TWC_WareHouse where bUsed=1 ";
if (StockId.Trim() != "")
{
sqlStr += " where cWHId='" + StockId + "'";
}
if (UserInformation.UType != UserType.utSupervisor)
{
sqlStr += " and cWHId in (select cWHId from TPB_UserWHouse where cUserId='" + UserInformation.UserId.Trim() + "')";
}
DataSet ds = PubDBCommFuns.GetDataBySql(sqlStr, out errStr); //UserManager.GetDataSetbySql(sql);
comboBox_cWHId.DataSource = ds.Tables["data"];
comboBox_cWHId.DisplayMember = "cName";
comboBox_cWHId.ValueMember = "cWHId";
DataTable tbX = ds.Tables["data"].Copy();
this.cmbQ_WHId.DataSource = tbX;
cmbQ_WHId.DisplayMember = "cName";
cmbQ_WHId.ValueMember = "cWHId";
}
private void InitWareHouse()
{
string strSql = "select * from TWC_WareHouse where bUsed=1 ";
if (UserInformation.UType != UserType.utSupervisor)
{
strSql += " and cWHId in (select cWHId from TPB_UserWHouse where cUserId='" + UserInformation.UserId.Trim() + "')";
}
string err = "";
DataTable tbWare = new DataTable();
try
{
DataSet dsY = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, strSql, "TWC_WareHouse", "", out err);
if (err != "")
{
MessageBox.Show(strSql, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
tbWare = dsY.Tables["TWC_WareHouse"].Copy();
cmbWHId.DisplayMember = "cName";
cmbWHId.ValueMember = "cWHId";
cmbWHId.DataSource = tbWare;
}
cmbWHId.SelectedIndex = -1;
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
}
private void frmCompany_Load(object sender, EventArgs e)
{
#region 权限控制
tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118";
string sErr = "";
StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'");
if (UserInformation.UserName != "Admin5118")
{
sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')");
}
DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
if (UserInformation.UserName != "Admin5118")
{
CheckRights(tlbMain, dsX.Tables["UserRights"]);
}
#endregion
strConnFix = "";
if (UserInformation.UType != UserType.utSupervisor)
{
strConnFix = " where cComptId='" + UserInformation.UnitId + "'";
}
else
{
sbConndition.Remove(0, sbConndition.Length);
}
OpenMainDataSet(strConnFix);
}
private void OpenWorkDtlList(string sWorkId)
{
string sErr = "";
string sSql = "select * from " + this.strTbDtl + " where nWorkId='" + sWorkId.Trim() + "'";
Cursor.Current = Cursors.WaitCursor;
DataSet set = PubDBCommFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, this.strTbDtl, 0, 0, "", out sErr);
Cursor.Current = Cursors.Default;
if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
{
MessageBox.Show(sErr);
}
else if (set == null)
{
MessageBox.Show("打开任务明细时，出错！");
}
else
{
this.bIsOpenForDtl = false;
this.grdDtl.AutoGenerateColumns = false;
this.grdDtl.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.bsDtl.DataSource = set.Tables[this.strTbDtl];
this.grdDtl.DataSource = this.bsDtl;
this.bIsOpenForDtl = true;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.bsMain.Count == 0)
{
MessageBox.Show("无任务数据！");
}
else
{
DataRowView current = (DataRowView)this.bsMain.Current;
if (current == null)
{
MessageBox.Show("无任务数据！");
}
else
{
string str = current["nWorkId"].ToString().Trim();
string sErr = "";
if (current["nWHType"].ToString().Trim().Trim() != "1")
{
MessageBox.Show("属于平库任务，系统将进行直接过账！");
}
string str4 = PubDBCommFuns.sp_Do_WKTaskDtlIsOK(base.AppInformation.SvrSocket, int.Parse(str.Trim()), base.UserInformation.UserName.Trim(), base.UserInformation.UnitId, "WMS", out sErr);
if (((str4.Trim() != "0") && (str4.Trim() != "")) && (sErr.Trim() != ""))
{
MessageBox.Show(sErr);
}
else
{
MessageBox.Show("任务确认成功！");
this.OpenWorkTaskList();
}
}
}
}
private void btn_SelItemType_Click(object sender, EventArgs e)
{
DataSet set = null;
string sErr = "";
string sSql = "";
string sFldsDate = "";
Button button = (Button)sender;
sSql = "select cTypeId,cTypeName from TPC_MaterialType where ctypemode=0";
sFldsDate = "";
Cursor.Current = Cursors.WaitCursor;
set = PubDBCommFuns.GetDataBySql(base.AppInformation.SvrSocket, sSql, sFldsDate, out sErr);
Cursor.Current = Cursors.Default;
if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
{
MessageBox.Show(sErr);
}
else
{
frmSelItemList list = new frmSelItemList();
DataTable table = set.Tables["data"];
list.TableItem = table;
list.TitleText = "物料类别选择";
list.FldDesc = "cTypeName";
list.FldKey = "cTypeId";
list.ShowDialog();
if (list.IsSelected)
{
this.txt_ItemType.Text = list.SelectItemList;
this.txt_ItemType.Tag = list.SelectKeyList;
}
list.Dispose();
set.Clear();
}
}
private int GetMaterialQCState(string sMNo)
{
int nState = 1;
string sSql = "select isnull(bIsQC,1) bIsQC from TPC_Material where cMNo='" + sMNo.Trim() + "'";
object objX = null;
string sErr = "";
PubDBCommFuns.GetValueBySql(AppInformation.SvrSocket, sSql, "", "bIsQC", out objX, out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
else if (objX != null)
{
nState = int.Parse(objX.ToString());
if (nState == 1)
{
nState = 0;
}
else
{
nState = 1;
}
}
return(nState);
}
private bool OpenItemList(string sItemValue)
{
bool flag = false;
StringBuilder builder = new StringBuilder("");
builder.Append("select * from TPC_Material ");
if (sItemValue.Trim() != "")
{
builder.Append(" where (cMNo like '%" + sItemValue.Trim() + "%') or (cName like '%" + sItemValue.Trim() + "%') or (isnull(cPYJM,' ') like '%" + sItemValue.Trim().ToUpper() + "%') or (isnull(cWBJM,' ') like '%" + sItemValue.Trim().ToUpper() + "%')");
}
if (this.dsItemList.Tables["data"] != null)
{
this.dsItemList.Tables["data"].Clear();
}
this.grdDtl.AutoGenerateColumns = false;
string sErr = "";
this.dsItemList = PubDBCommFuns.GetDataBySql(builder.ToString(), out sErr);
flag = this.dsItemList.Tables[0].Rows[0][0].ToString() == "0";
if (this.dsItemList.Tables[0].Rows[0][0].ToString() == "0")
{
this.bdsItemList.DataSource = this.dsItemList.Tables["data"];
this.grdDtl.DataSource = this.bdsItemList;
}
else
{
MessageBox.Show(this.dsItemList.Tables[0].Rows[0][0].ToString());
}
this.grdDtl.Visible = true;
return(flag);
}
private bool CheckCodeIsExists(string sTbName, string sFldCode, string sCode, out int nCount)
{
bool flag = false;
string sErr = "";
nCount = -1;
DataSet dataBySql = PubDBCommFuns.GetDataBySql("Select count(*) nCount from " + sTbName + " where " + sFldCode + "='" + sCode.Trim() + "'", out sErr);
if (sErr.Length > 0)
{
MessageBox.Show(" 检测 编码是否存在时报错：" + sErr);
return(flag);
}
DataTable table = null;
table = dataBySql.Tables["result"];
if (table.Rows[0]["returncode"].ToString() != "0")
{
MessageBox.Show(" 检测 编码是否存在时报错：" + table.Rows[0]["returndesc"].ToString());
dataBySql.Clear();
return(flag);
}
table = dataBySql.Tables["data"];
if (table != null)
{
nCount = int.Parse(table.Rows[0]["nCount"].ToString());
flag = true;
}
if (dataBySql != null)
{
dataBySql.Clear();
}
return(flag);
}
public void DataRowToUI()
{
if (this.drvItem == null)
{
MessageBox.Show("对不起，物料明细数据行对象为空！");
}
else
{
this.bIsShowGrid = false;
this.DataRowViewToUI(this.drvItem, this.pnlDtlEdit);
this.bIsShowGrid = true;
if ((!this.bIsNew && this.isOutBill) && (this.txt_Dtl_fQty.Text.Trim() != ""))
{
string sErr = "";
double pCurUsedQty = double.Parse(this.txt_Dtl_fQty.Text.Trim());
pCurUsedQty = PubDBCommFuns.sp_Pack_GetItemBillQty(base.AppInformation.SvrSocket, 0, this.txt_Dtl_cMNo.Text.Trim(), this._WHId.Trim(), this._MatClass.Trim(), this._QCStatus, "", pCurUsedQty, out sErr);
if ((sErr.Trim() == "") || (sErr.Trim() == "0"))
{
this.fUseQty = pCurUsedQty;
this.lbl_Out.Text = "可出数：" + pCurUsedQty.ToString() + " (可出数 =库存数-待出数)";
}
else
{
MessageBox.Show(sErr);
}
}
}
}
private void DoSelectMat(string sMNo, string sMName, string sSpec, string sMatStyle, string sMatQCLevel, string sMatOther, string sRemark, string sABC, double fSafeQtyDn, double fSafeQtyUp, double fQtyBox, double fWeight, string sTypeId1, string sType1, string sTypeId2, string sType2, string sUnit, int nKeepDay, string sCSId, string sSupplier, int _nMatClass, bool bIsSelectOK)
{
if (bIsSelectOK)
{
this.txt_Dtl_cMatOther.Text = sMatOther.Trim();
this.txt_Dtl_cMatQCLevel.Text = sMatQCLevel.Trim();
this.txt_Dtl_cMatStyle.Text = sMatStyle.Trim();
this.txt_Dtl_cMName.Text = sMName.Trim();
this.txt_Dtl_cMNo.Text = sMNo;
this.txt_Dtl_cSpec.Text = sSpec.Trim();
this.txt_Dtl_cSupplier.Text = sSupplier.Trim();
this.txt_Dtl_cUnit.Text = sUnit;
if (this.bIsNew && this.isOutBill)
{
string sErr = "";
double num = 0.0;
num = PubDBCommFuns.sp_Pack_GetItemBillQty(base.AppInformation.SvrSocket, 0, this.txt_Dtl_cMNo.Text, this._WHId.Trim(), this._MatClass.Trim(), this._QCStatus, "", 0.0, out sErr);
if ((sErr.Trim() == "") || (sErr.Trim() == "0"))
{
this.fUseQty = num;
this.lbl_Out.Text = "可出数：" + num.ToString() + " (可出数 =库存数-待出数)";
}
else
{
MessageBox.Show(sErr);
}
}
}
}
private void frmUserInfo_Load(object sender, EventArgs e)
{
#region 权限控制
tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118";
string sErr = "";
StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'");
if (UserInformation.UserName != "Admin5118")
{
sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')");
}
DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
if (UserInformation.UserName != "Admin5118")
{
CheckRights(tlbMain, dsX.Tables["UserRights"]);
}
#endregion
string sCon = "";
LoadBaseItem();
sCon = GetDataCondition();
OpenMainDataSet(sCon);
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.bsGrid.Count == 0)
{
MessageBox.Show("对不起，没有任务数据可下发！");
}
else if ((this.grdData.SelectedRows != null) && (this.grdData.SelectedRows.Count == 0))
{
MessageBox.Show("对不起，没有选择要下发的任务数据！");
}
else
{
int num = 0;
foreach (DataGridViewRow row in this.grdData.SelectedRows)
{
if (int.Parse(row.Cells[this.colnStatus.Name].Value.ToString()) < 1)
{
string sErr = "";
if ((PubDBCommFuns.sp_Chk_DoCheckTask(base.AppInformation.SvrSocket, base.UserInformation.UserName, "WMS", base.UserInformation.UnitId, row.Cells[this.colcPosId.Name].Value.ToString().Trim(), int.Parse(this.cmb_Station.Text.Trim()), this._CheckNo, out sErr) == "0") || (sErr.Trim() == ""))
{
num++;
}
}
}
MessageBox.Show("已经成功下发：" + num.ToString() + " 条盘点任务！");
this._IsOK = num > 0;
base.Close();
}
}
private void mi_DoAccountAll_Click(object sender, EventArgs e)
{
DataRowView drvMain = (DataRowView)bindingSource_Main.Current;
if (drvMain == null)
{
MessageBox.Show("无调整单数据可过账！");
return;
}
if (int.Parse(drvMain["nStatus"].ToString()) == 2)
{
MessageBox.Show("该调整单：" + drvMain["cBNo"].ToString() + "已经被审核");
return;
}
string sErr = "";
//string sX = PubDBCommFuns.sp_Chk_UpdtQtyFromAjustB(AppInformation.SvrSocket, UserInformation.UnitId, UserInformation.UserName, "WMS", drvMain["cBNo"].ToString().Trim(), out sErr);
string sX = PubDBCommFuns.sp_Pack_BillCheck(AppInformation.SvrSocket, int.Parse(drvMain["nBClass"].ToString()), drvMain["cBNo"].ToString(), 0, UserInformation.UserId, UserInformation.UnitId, "WMS", out sErr);
if (sX.Trim() != "0")
{
MessageBox.Show(sErr);
return;
}
else
{
MessageBox.Show("审核成功！");
}
DoRefresh();
}
private void LoadBoxType()
{
string sErr = "";
string sSql = "select distinct cBoxType from twc_box ";
DataSet dataBySql = PubDBCommFuns.GetDataBySql(sSql, out sErr);
if (sErr.Length > 0)
{
MessageBox.Show(sErr);
if (dataBySql != null)
{
dataBySql.Clear();
}
}
else
{
this.cmb_cBoxType.DataSource = dataBySql.Tables["data"];
this.cmb_cBoxType.DisplayMember = "cBoxType";
this.cmb_cBoxType.ValueMember = "cBoxType";
DataTable table = null;
table = dataBySql.Tables["data"].Copy();
this.cmbQ_cBoxType.DataSource = table;
this.cmbQ_cBoxType.DisplayMember = "cBoxType";
this.cmbQ_cBoxType.ValueMember = "cBoxType";
}
}
private void ReadSysPar()
{
string sErr = "";
string sSql = "select * from tps_syspar where cParId='WarehouseIdIsManual'";
DataSet dataBySql = null;
dataBySql = PubDBCommFuns.GetDataBySql(sSql, out sErr);
if (sErr.Length > 0)
{
MessageBox.Show(sErr);
}
else if (dataBySql == null)
{
MessageBox.Show("从数据库中读取系统参数时，出错！");
}
else
{
DataTable table = dataBySql.Tables["data"];
DataRow row = table.Rows[0];
object obj2 = row["cParValue"];
if (obj2 != null)
{
this.bCodeIsManual = obj2.ToString().Trim() == "1";
}
dataBySql.Clear();
}
}
private bool BandDataSet(string SqlStrConditon, DataGridView FDataGridView)
{
this.LoadBoxType();
bool flag = true;
string sSql = "";
string sErr = "";
this.bDSIsOpenForMain = false;
FDataGridView.AutoGenerateColumns = false;
FDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
base.DBDataSet.Clear();
sSql = "select * from " + this.strTbNameMain + " " + SqlStrConditon;
base.DBDataSet = PubDBCommFuns.GetDataBySql(sSql, this.strTbNameMain, 0, 0, out sErr);
flag = base.DBDataSet != null;
this.bindingSource_Main.DataSource = base.DBDataSet.Tables[this.strTbNameMain];
FDataGridView.DataSource = this.bindingSource_Main;
if (this.bindingSource_Main.Count > 0)
{
try
{
this.bDSIsOpenForMain = true;
this.DataRowViewToUI((DataRowView)this.bindingSource_Main.Current, this.panel_Edit);
this.OptMain = OperateType.optNone;
}
catch (Exception exception)
{
this.bDSIsOpenForMain = false;
MessageBox.Show(exception.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Hand);
flag = false;
}
}
return(flag);
}
/// <summary>
/// 绑定货区的信息
/// </summary>
private void BindAreaName()
{
//select CAREAID,CAREANAME from TWC_WAREA
string strSql = string.Format("select CAREAID,CAREANAME from TWC_WAREA ");
string err = "";
DataTable tbWare = new DataTable();
try
{
DataSet dsY = PubDBCommFuns.GetDataBySql(strSql, out err);
if (err != "" && err != "0")
{
MyTools.MessageBox(err);
}
else
{
tbWare = dsY.Tables["data"].Copy();
this.cmbArea.DisplayMember = "CAREANAME";
this.cmbArea.ValueMember = "CAREAID";
this.cmbArea.DataSource = tbWare;
this.cmbArea.SelectedIndex = -1;
}
}
catch (Exception er)
{
MyTools.MessageBox(er.Message);
}
}
private void tlb_M_Find_Click(object sender, EventArgs e)
{
string sWHId = "";
string sBTypeId = "";
string sErr = "";
if (cmbWHId.Text.Trim() != "" && cmbWHId.SelectedValue != null)
{
sWHId = cmbWHId.SelectedValue.ToString();
}
if (cmb_cBillType.Text.Trim() != "" && cmb_cBillType.SelectedValue != null)
{
sBTypeId = cmb_cBillType.SelectedValue.ToString();
}
Cursor.Current = Cursors.WaitCursor;
dsData = PubDBCommFuns.sp_GetIOListExt(AppInformation.SvrSocket, 0, sWHId, txt_cMNo.Text.Trim(), sBTypeId, txt_cBNo.Text.Trim(), dtp_From.Value.ToString(), dtp_To.Value.ToString(),
cmb_cEventType.Text.Trim(), cmb_cMatClass.Text.Trim(), cmb_cEventAddr.Text.Trim(), cmb_cStartLevel.Text.Trim(), txt_cFileNo.Text.Trim(), out sErr);
Cursor.Current = Cursors.Default;
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
return;
}
grdData.DataSource = dsData.Tables[1];
dsData.Tables[1].TableName = "IOList_Ext";
}
public void InitCmb()
{
string strSql = "select * from TWC_WareHouse where bUsed=1 ";
if (UserInformation.UType != UserType.utSupervisor)
{
strSql += " and cWHId in (select cWHId from TPB_UserWHouse where cUserId='" + UserInformation.UserId.Trim() + "')";
}
string err = "";
DataTable tbWare = new DataTable();
try
{
DataSet dsY = PubDBCommFuns.GetDataBySql(strSql, out err);
if (err != "" && err != "0")
{
MyTools.MessageBox(err);
}
else
{
tbWare = dsY.Tables["data"].Copy();
cmbWHId.DisplayMember = "cName";
cmbWHId.ValueMember = "cWHId";
cmbWHId.DataSource = tbWare;
cmbWHId.SelectedIndex = -1;
}
}
catch (Exception er)
{
MyTools.MessageBox(er.Message);
}
}
public void DataRowToUI()
{
if (drvItem == null)
{
MessageBox.Show("对不起，物料明细数据行对象为空！");
}
else
{
bIsShowGrid = false;
DataRowViewToUI(drvItem, pnlDtlEdit);
bIsShowGrid = true;
if ((!bIsNew))
{
//获取可用数量
if (txt_Dtl_fQty.Text.Trim() != "")
{
string sErr = "";
double fQty = double.Parse(txt_Dtl_fQty.Text.Trim());
fQty = PubDBCommFuns.sp_Pack_GetItemBillQty(AppInformation.SvrSocket, 0, txt_Dtl_cMNo.Text.Trim(), _WHId.Trim(), _QCStatus, "", fQty, out sErr);
if (sErr.Trim() == "" || sErr.Trim() == "0")
{
fUseQty = fQty;
//lbl_Out.Text = "可出数：" + fQty.ToString() + " (可出数 =库存数-待出数)";
}
else
{
MessageBox.Show(sErr);
}
}
}
}
}
/// <summary>
/// 按仓库统计物料的明细数据
/// </summary>
/// <param name="sMNo"></param>
/// <param name="sBatchNo"></param>
/// <returns></returns>
private DataTable GetDataAtMatDtl(string sMNo, string sBatchNo)
{
GetTxtValue();
string err = "";
string sql = "";
sql = "select * from V_StoreItemList where cMNo='" + sMNo + "' ";
sql += whereInfoStr();
//sql += whereInfoStr1();
if (cbxIscBatchNoGroup.Checked)
{
sql += (" and cBatchNo='" + sBatchNo + "' ");
}
DataSet dsY = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, false, sql, "data", 0, 0, "dInTime", out err);
if (err == "" || err == "0")
{
return(dsY.Tables["data"]);
}
else
{
MyTools.MessageBox(err);
return(new DataTable());
}
}
private void OpenWorkTaskList()
{
string sErr = "";
string sSql = "select * from " + this.strTbMain + " where isnull(bIsAllowReturnBack,0) < 1 and (nWKStatus between 1 and 98 )";
if (base.UserInformation.UType != UserType.utSupervisor)
{
sSql = sSql + " and cUser='******'";
}
Cursor.Current = Cursors.WaitCursor;
DataSet set = PubDBCommFuns.GetDataBySql(base.AppInformation.SvrSocket, false, sSql, this.strTbMain, 0, 0, "", out sErr);
Cursor.Current = Cursors.Default;
if ((sErr.Trim() != "") && (sErr.Trim() != "0"))
{
MessageBox.Show(sErr);
}
else if (set == null)
{
MessageBox.Show("打开任务主表时，出错！");
}
else
{
this.bIsOpenForMain = false;
this.grdMain.AutoGenerateColumns = false;
this.grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
this.bsMain.DataSource = set.Tables[this.strTbMain];
this.grdMain.DataSource = this.bsMain;
this.bIsOpenForMain = true;
this.bsMain_PositionChanged(null, null);
}
}
private DataTable GetDataAtBalltToRpts( )
{
/*
* 取得按托盘的报表数据
*/
string err = "";
string sql = string.Format("select * from (select cItemId,cMName,cSpec,cBatchNo,sum(fQty) fQty ,max(cUnit) cUnit,max(cMatOther) cMatOther,max(cMatStyle) cMatStyle, nPalletId,max(cBoxId) cBoxId, max(cQCStatus) cQCStatus,max(cTypeId1) cTypeId1,max(cTypeId2) cTypeId2,max(cDept) cDept from V_StoreItemList where 1=1 ");
sql += whereInfoStr();
//if (pallStr != "")
//{
// sql += string.Format(" and nPalletId ='{0}' ", pallStr);
//}
//sql += whereInfoStr1();
sql += string.Format(" group by cItemId,cMName,cSpec,cBatchNo,nPalletId) ");
//sql += whereInfoStr1();
DataSet dsY = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, false, sql, "data", 0, 0, "dInTime", out err);
if (err == "" || err == "0")
{
return(dsY.Tables["data"]);
}
else
{
MyTools.MessageBox(err);
return(new DataTable());
}
}
private void OpenCellItemList(string sCellId)
{
string sPalletId = "";
string sErr = "";
object objX = null;
PubDBCommFuns.GetValueBySql(AppInformation.SvrSocket, "select isnull(nPalletId,'') nPalletId from TWC_WareCell where cPosId='" + sCellId.Trim() + "'", "", "nPalletId", out objX, out sErr);
if (sErr.Trim() != "" && sErr.Trim() == "0")
{
MessageBox.Show(sErr);
return;
}
if (objX != null)
{
sPalletId = objX.ToString();
}
if (sPalletId.Trim() == "")
{
sPalletId = "~";
}
string sWHId = cmb_cWHId.SelectedValue.ToString();
//StringBuilder sSql = new StringBuilder("select * from V_StoreItemList");
DataTable tbX = PubDBCommFuns.sp_Pack_GetItemList(AppInformation.SvrSocket, sPalletId, sWHId, "", 1, out sErr);
if ((sErr != "0") && (sErr.Trim().Length != 0))
{
MessageBox.Show(sErr);
}
else
{
bdsList.DataSource = tbX;
grdList.DataSource = bdsList;
}
}
/// <summary>
/// 绑定物料类型
/// </summary>
private void BindMatType()
{
//select CTYPEID,CTYPENAME from TPC_MATERIALTYPE
string strSql = string.Format("select CTYPEID,CTYPENAME from TPC_MATERIALTYPE ");
string err = "";
DataTable tbWare = new DataTable();
try
{
DataSet dsY = PubDBCommFuns.GetDataBySql(strSql, out err);
if (err != "" && err != "0")
{
MyTools.MessageBox(err);
}
else
{
tbWare = dsY.Tables["data"].Copy();
this.cmb_cTypeId1.DisplayMember = "CTYPENAME";
this.cmb_cTypeId1.ValueMember = "CTYPEID";
this.cmb_cTypeId1.DataSource = tbWare;
this.cmb_cTypeId1.SelectedIndex = -1;
}
}
catch (Exception er)
{
MyTools.MessageBox(er.Message);
}
}
private void OpenWareAreaList(string sWHId)
{
string strSql = "select * from TWC_WArea where bUsed=1 and cWHId='" + sWHId.Trim() + "'";
string err = "";
DataTable tbX = new DataTable();
try
{
DataSet dsY = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, strSql, "TWC_WArea", "", out err);
if (err != "")
{
MessageBox.Show(strSql, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
tbX = dsY.Tables["TWC_WArea"].Copy();
cmb_Area.DisplayMember = "cAreaName";
cmb_Area.ValueMember = "cAreaId";
cmb_Area.DataSource = tbX;
}
cmb_Area.SelectedIndex = -1;
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
}
private bool DoPrint()
{
bool flag = false;
if (this.bindingSource_Main.Count == 0)
{
MessageBox.Show("对不起，无数据可打印！");
return(false);
}
DataRowView current = (DataRowView)this.bindingSource_Main.Current;
string str = "";
string sErr = "";
string sValue = "";
base.ReadConfigXMLValue(base.AppInformation.AppConfigFile, "config/printers", "BarCode_BoxId", "", "", out sValue);
str = current["cBoxId"].ToString();
if (flag)
{
PubDBCommFuns.GetDataBySql("update TWC_Box set bIsPrint=1 where cBoxId='" + str + "'", out sErr);
if (sErr.Length > 0)
{
MessageBox.Show(sErr);
}
}
return(flag);
}
private void tlbSaveSysRts_Click(object sender, EventArgs e)
{
#region 工具栏
//foreach (ToolStripButton btnX in tlbMain.Items)
foreach (ToolStripItem btnX in tlbMain.Items)
{
object objX = btnX.Tag;
if (objX != null)
{
string sErr = "";
string sCName = btnX.Text;
string sRCode = btnX.Name;
string sRID = ModuleRtsId + objX.ToString();
PubDBCommFuns.sp_SaveSysRight(AppInformation.SvrSocket, ModuleRtsId, sRID, sCName, "", sRCode, 3, "Sys", out sErr);
}
}
#endregion
#region 其他
//foreach (Control ctrlX in pnlBtns.Controls)
//{
// object objX = ctrlX.Tag;
// if (objX != null)
// {
// string sErr = "";
// string sCName = ctrlX.Text;
// string sRCode = ctrlX.Name;
// string sRID = ModuleRtsId + objX.ToString();
// PubDBCommFuns.sp_SaveSysRight(AppInformation.SvrSocket, ModuleRtsId, sRID, sCName, "", sRCode, 3, "Sys", out sErr);
// }
//}
#endregion
}
private void FrmStockInfo_Load(object sender, EventArgs e)
{
#region 权限控制
tlbSaveSysRts.Visible = UserInformation.UserName == "Admin5118";
string sErr = "";
StringBuilder sSql = new StringBuilder("select * from TPB_Rights where cPRId ='" + ModuleRtsId.Trim() + "'");
if (UserInformation.UserName != "Admin5118")
{
sSql.Append(" and cRId in (select cRId from TPB_URTS where cUserId='" + UserInformation.UserId.Trim() + "')");
}
DataSet dsX = PubDBCommFuns.GetDataBySql(AppInformation.SvrSocket, sSql.ToString(), "UserRights", "", out sErr);
if (sErr.Trim() != "" && sErr.Trim() != "0")
{
MessageBox.Show(sErr);
}
CheckRights(tlbMain, dsX.Tables["UserRights"]);
#endregion
LoadCommboxItemByValue();
LoadStockList("");
LoadCheckType("");
dtp_To.Value = DateTime.Now;
dtp_From.Value = DateTime.Now.AddDays(-30);
BandDataSet("", this.dataGridView_Main);
}
