/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemBuyFormRule rule = new ItemBuyFormRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemBuyFollowRule rule = new ItemBuyFollowRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
string sql = "SELECT FormNo,ShopID,ReqDate,MakeDate,TotalQty FROM Buy_ItemBuyForm WHERE 1=1";
sql += " AND FormNo NOT IN (SELECT BuyFormNo FROM Buy_ItemBuyFollow";
if (saveNoLoadCheckDayNum != 0)
{
sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
}
sql += ") ";
if (ChkMakeDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtBuyDateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtBuyDateE.DateTime.ToString("yyyy-MM-dd"));
}
sql += " AND SubmitFlag=1 ORDER BY FormNo DESC ";
DataTable dt = SysUtils.Fill(sql);
gridView2.GridControl.DataSource = dt;
gridView2.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
FlowerTypeContolRule rule = new FlowerTypeContolRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid数据
/// </summary>
private void BindGrid()
{
VendorRule rule = new VendorRule();
gridView1.GridControl.DataSource = rule.RShow(conditionstr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
string sql = string.Empty;// " AND ItemTypeID=" + SysString.ToDBString((int)EnumItemType.面料);
string itemtypestr = "0";
for (int i = 0; i < HTItemTypeIDA.Length; i++)
{
itemtypestr += ",";
itemtypestr += HTItemTypeIDA[i];
}
sql = " AND ItemTypeID IN(" + itemtypestr + ")";
if (ItemClassArray != "-1" && ItemClassArray != "")
{
sql += " AND ItemClassID IN(" + ItemClassArray + ")";
}
ItemRule rule = new ItemRule();
DataTable dt = rule.RShowColor(sql + HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
for (int i = 0; i < dt.Rows.Count; i++)
{
if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"])))
{
dt.Rows[i]["SelectFlag"] = 1;
}
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShow2(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("FaHuoStatusName", "'' FaHuoStatusName"));
//SaleOrderStatusProc.ProcColorStatusName(dt);
ProFaHuoStatusName(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
//string sql = "SELECT COUNT( ID) FROM UV1_Sale_SaleOrderDts WHERE 1=1";
//sql += HTDataConditionStr + " GROUP BY ID";
//DataTable dtSO = SysUtils.Fill(sql);
//if (dtSO.Rows.Count > 0)
//{
// lbCount.Text = "销售合同数：" + dtSO.Rows[0][0].ToString();
//}
//else
//{
// lbCount.Text = "销售合同数：0";
//}
//if (ProductParamSet.GetIntValueByID(5418) == (int)YesOrNo.Yes)//更新回签标志
//{
// sql = "UPDATE Sale_SaleOrder SET HQFlag=1 WHERE FormNo IN (SELECT ISNULL(FileProt2,'') FROM Data_WinListAttachFile WHERE FileProt1=" + SysString.ToDBString(this.Text) + ")";
// SysUtils.ExecuteNonQuery(sql);
//}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderTFabricCompSiteRule rule = new SaleOrderTFabricCompSiteRule();
gridView1.GridControl.DataSource = rule.RShowView(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
IOFormRule rule = new IOFormRule();
HTDataConditionStr += "GROUP BY FormNo,";
HTDataConditionStr += "FormDate,ItemCode,DtsOrderFormNo,";
HTDataConditionStr += "WHNM,FormNM,ColorNum,ColorName,MWidth,";
HTDataConditionStr += "MWeight,SinglePrice,ID,ItemName,ItemStd,ItemModel";
DataTable dt = rule.RShowDtsTotal(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("Amount", "SUM(Amount) Amount").Replace("Qty", "SUM(Qty) Qty"));
//if (m_DZFlag == 1)
//{
// SetDZGridView(dt);
//}
//if (m_InvoiceFlag == 1)
//{
// SetInvoiceGridView(dt);
//}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"])))
{
dt.Rows[i]["SelectFlag"] = 1;
}
}
//SetWHQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
//IOFormRule rule = new IOFormRule();
string ConditionAttn = " AND HeadType=" + this.FormListAID;
ConditionAttn += " AND SubType in(Select ID FROM Enum_FormList WHERE IsShow=1 )";
//ConditionAttn += " AND WHID in(Select WHID FROM WH_WH WHERE isnull(IsJK,0)=0 )";//2012-2-23caoxg
//gridView2.GridControl.DataSource = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2));
//gridView2.GridControl.Show();
IOFormDtsRule rule = new IOFormDtsRule();
//gridView2.GridControl.DataSource = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2));
DataTable dt = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2).Replace("MakeOPName", "''MakeOPName"));
ProductMakeOP(dt);
gridView2.GridControl.DataSource = dt;
gridView2.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
private void BindGridDts()
{
IOFormDtsRule rule = new IOFormDtsRule();
gridView2.GridControl.DataSource = rule.RShow(HTDataID, ProcessGrid.GetQueryField(gridView2));
gridView2.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ProductionNoticeRule rule = new ProductionNoticeRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
CustomRule rule = new CustomRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定疵点明细
/// </summary>
private void BindGrid()
{
CheckOrderISNFaultRule rule = new CheckOrderISNFaultRule();
gridView1.GridControl.DataSource = rule.RShow(" AND MainID=" + ISNID, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SampleRule rule = new SampleRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
ProcessGrid.SetGridEdit(gridView1, new string[] { "EventStatus" }, true);
}
/// <summary>
/// 绑定Grid1
/// </summary>
public void BindGrid1()
{
GBJCDtsRule rule = new GBJCDtsRule();
DataTable dtt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定卡片
/// </summary>
void BindGridCard()
{
ItemGBRule rule = new ItemGBRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("VendorName", "'' VendorName"));
cardView1.GridControl.DataSource = dt;
cardView1.GridControl.Show();
}
void work_DoWork(object sender, DoWorkEventArgs e)
{
StorgeAlarmRule rule = new StorgeAlarmRule();
GridView1Table = rule.RShowStorge(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("YCFlag", "0 AS YCFlag"));
//IOFormRule rule = new IOFormRule();
//GridView1Table = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
StorgeAlarmRule rule = new StorgeAlarmRule();
DataTable dt = rule.RShowStorge(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("YCFlag", "0 AS YCFlag"));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
PackBoxRule rule = new PackBoxRule();
DataTable dt = rule.RUShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
IOFormDtsISNRule rule = new IOFormDtsISNRule();
gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
gridView1.GridControl.Show();
ProcessGrid.SetGridEdit(HTDataList, new string[] { "SelectFlag" }, true);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
GoodsPostRule rule = new GoodsPostRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SendDes", "'' SendDes"));
SetGrid(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
IOFormRule rule = new IOFormRule();
DataTable dt = rule.RShowDtsPack(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SQty", "0.00 SQty"));
SetGridView(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
QSRule rule = new QSRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag"));
setDt(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
if (SysConvert.ToString(drpQWHID.EditValue) == "")
{
this.ShowMessage("请选择仓库");
return;
}
string FormDateS = "2014-01-01";
string FormDateE = "2222-01-01";
if (chkFormDate.Checked)
{
FormDateS = txtFormDateS.DateTime.ToString("yyyy-MM-dd");
FormDateE = txtFormDateE.DateTime.ToString("yyyy-MM-dd");
}
string sql = string.Empty;
sql = "SELECT ID FROM WH_StorgeJS WHERE JSDateS=" + SysString.ToDBString(FormDateS) + " AND JSDateE=" + SysString.ToDBString(FormDateE);
sql += " AND JSFlag=1";
DataTable dtJS = SysUtils.Fill(sql);
//string sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr);
//DataTable dt = SysUtils.Fill(sql);
//gridView1.GridControl.DataSource = dt;
//gridView1.GridControl.Show();
DataTable dt;
if (dtJS.Rows.Count != 0)//同样的日期范围有结算数据，直接访问结算数据
{
StorgeJSDtsRule rule = new StorgeJSDtsRule();
string conditionStr = " AND MainID=" + SysString.ToDBString(dtJS.Rows[0]["ID"].ToString());
if (!Common.CheckLookUpEditBlank(drpQWHID))
{
conditionStr += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue));
}
conditionStr += GetConditionStr();
dt = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView1));
lblQueryDesc.Text = "好快，你查询的可是仓库结算数据哦！！！";
Application.DoEvents();
}
else
{
lblQueryDesc.Text = "数据量较大，查询较慢，请耐心等待。";
Application.DoEvents();
int timeout = SystemConfiguration.DBTimeOut;
SystemConfiguration.DBTimeOut = 100000;
sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue)) + "," + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr);
dt = SysUtils.Fill(sql);
SystemConfiguration.DBTimeOut = timeout;
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid3
/// </summary>
public void BindGrid3()
{
GBJCDtsRule rule = new GBJCDtsRule();
string ConditionStr = HTDataConditionStr;
ConditionStr += " AND GHTime IS NULL AND SubmitFlag=1";
gridView3.GridControl.DataSource = rule.RShow(ConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView3.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
CheckOperationDtsRule rule = new CheckOperationDtsRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark"));
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemTestFormRule rule = new ItemTestFormRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("UseFlag", "0 UseFlag").Replace("TestItemName", "'' TestItemName"));
AddUseFlag(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
private void BindGrid()
{
if (HTFormStatus != FormStatus.新增 && HTFormStatus != FormStatus.修改)
{
IOFormRule rule = new IOFormRule();
gridView2.GridControl.DataSource = rule.RShowDts(GetCondition(), ProcessGrid.GetQueryField(gridView2));
gridView2.GridControl.Show();
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SampleSaleRule rule = new SampleSaleRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
//ProcessGrid.SetGridEdit(gridView1, new string[] { "FinishedFlag" }, true);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
FabricProcessRule rule = new FabricProcessRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("OrderStepName", "'' OrderStepName"));
ProcDt(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}