private void setItemNews(string p_Str)
{
string[] orderid = p_Str.Split(',');
for (int i = 0; i < orderid.Length; i++)
{
string sql = "SELECT * FROM UV1_Sale_SaleOrderDts WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[i]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
if (HTFormStatus == FormStatus.新增)
{
if (SysConvert.ToInt32(ProductParamSet.GetIntValueByID(6200)) == 2)//生产通知单单号启用新的生成规则：SR+年份+客户编码+01：SR14A00101
{
FormNoControlRule frule = new FormNoControlRule();
string vendorid = SysConvert.ToString(dt.Rows[0]["VendorID"]);
txtFormNo.Text = frule.RGetFormNo2((int)FormNoControlEnum.生产通知单号, vendorid);
}
}
gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"]));
gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["MWidth"]));
gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"]));
gridView1.SetRowCellValue(i, "Needle", SysConvert.ToString(dt.Rows[0]["Needle"]));
gridView1.SetRowCellValue(i, "SOQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]));
gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"]));
gridView1.SetRowCellValue(i, "VendorID", SysConvert.ToString(dt.Rows[0]["VendorAttn"]));
gridView1.SetRowCellValue(i, "SO", SysConvert.ToString(dt.Rows[0]["FormNo"]));
gridView1.SetRowCellValue(i, "LoadID", SysConvert.ToDecimal(dt.Rows[0]["DtsID"]));
drpSOTypeID.EditValue = SysConvert.ToInt32(dt.Rows[0]["OrderTypeID"]);
drpSaleOPID.EditValue = SysConvert.ToString(dt.Rows[0]["SaleOPID"]);
txtAddress.Text = Common.GetVendorAddress(dt.Rows[0]["VendorID"].ToString());
}
}
}
/// <summary>
/// 设置排单信息
/// </summary>
private void SetPDInfo()
{
try
{
// ProcessTypeID=" + SysString.ToDBString((int)EnumProcessType.织造加工单);
string info = string.Empty;
string sql = "select ProcessTypeID,SUM(ISNULL(TotalQty,0)) TotalQty from WO_FabricProcess WHERE 1=1";
sql += " AND ProductionID=" + SysString.ToDBString(HTDataID);
sql += " Group By ProcessTypeID ";
DataTable dtDts = SysUtils.Fill(sql);
if (dtDts.Rows.Count != 0)
{
for (int i = 0; i < dtDts.Rows.Count; i++)
{
if (SysConvert.ToInt32(dtDts.Rows[i]["ProcessTypeID"]) == (int)EnumProcessType.织造加工单)
{
info += " 织造排单数：" + SysConvert.ToString(dtDts.Rows[i]["TotalQty"]);
}
if (SysConvert.ToInt32(dtDts.Rows[i]["ProcessTypeID"]) == (int)EnumProcessType.染整加工单)
{
info += " 染整排单数：" + SysConvert.ToString(dtDts.Rows[i]["TotalQty"]);
}
if (SysConvert.ToInt32(dtDts.Rows[i]["ProcessTypeID"]) == (int)EnumProcessType.其他加工单)
{
info += " 后整理排单数：" + SysConvert.ToString(dtDts.Rows[i]["TotalQty"]);
}
if (SysConvert.ToInt32(dtDts.Rows[i]["ProcessTypeID"]) == (int)EnumProcessType.印花加工单)
{
info += " 印花排单数：" + SysConvert.ToString(dtDts.Rows[i]["TotalQty"]);
}
}
}
lblInfo.Text = info;
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void setItemNewsJCLR(string str)
{
string[] arr = str.Split(',');
int index = gridView1.FocusedRowHandle;
int length = 0;
for (int i = index; i < arr.Length + index; i++)
{
string sql = "SELECT * FROM UV2_Dev_GBJCLRDts WHERE DevDtsID=" + SysString.ToDBString(SysConvert.ToInt32(arr[length]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
//gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(i, "GBCode", SysConvert.ToString(dt.Rows[0]["GBCode"]));
gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"]));
gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
if (SysConvert.ToString(dt.Rows[0]["MWidth"]) != string.Empty)
{
gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["MWidth"]));
}
else
{
gridView1.SetRowCellValue(i, "MWidth", DBNull.Value);
}
if (SysConvert.ToString(dt.Rows[0]["MWeight"]) != string.Empty)
{
gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"]));
}
else
{
gridView1.SetRowCellValue(i, "MWeight", DBNull.Value);
}
gridView1.SetRowCellValue(i, "WeightUnit", SysConvert.ToString(dt.Rows[0]["WeightUnit"]));
gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"]));
gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
}
length++;
}
}
/// <summary>
/// 结算
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnJS_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
string tempstr = "";
string sql = "";
switch (this.FormListAID)
{
case 1:
tempstr += " AND VendorTypeID=" + (int)EnumVendorType.客户;
if (SysConvert.ToString(drpPlanOPID.EditValue) != "")
{
tempstr += " AND InSaleOP=" + SysString.ToDBString(drpPlanOPID.EditValue.ToString());
}
sql = "EXEC USP1_Finance_CapPlan " + SysString.ToDBString(tempstr) + ",'2012-01-01'," + SysString.ToDBString(txtFormDate.DateTime);
DataTable dt = SysUtils.Fill(sql);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
break;
case 2:
tempstr += " AND VendorTypeID=" + (int)EnumVendorType.工厂;
if (SysConvert.ToString(drpVendor2.EditValue) != "")
{
tempstr += " AND VendorID=" + SysString.ToDBString(drpVendor2.EditValue.ToString());
}
sql = "EXEC USP1_Finance_CapPlan2 " + SysString.ToDBString(tempstr) + ",'2012-01-01'," + SysString.ToDBString(txtFormDate.DateTime);
DataTable dto = SysUtils.Fill(sql);
gridView1.GridControl.DataSource = dto;
gridView1.GridControl.Show();
break;
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void gridViewRowChanged2(object sender)
{
try
{
BaseFocusLabel.Focus();
ColumnView view = sender as ColumnView;
string sql = "SELECT * FROM UV1_Sale_SaleOrderDts WHERE VendorID=" + SysString.ToDBString(SysConvert.ToString(gridView1.GetRowCellValue(view.FocusedRowHandle, "VendorID")));
if (chkMakeDate.Checked)
{
sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtMakeDateE.DateTime);
}
DataTable dt = SysUtils.Fill(sql);
gridView2.GridControl.DataSource = dt;
gridView2.GridControl.Show();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void drpGBStatusID_EditValueChanged(object sender, EventArgs e)
{
try
{
if (HTDataID != 0)
{
string sql = "SELECT * FROM Dev_GBJCLRDts WHERE MainID=" + SysConvert.ToInt32(HTDataID);
if (SysConvert.ToInt32(drpGBStatusID.EditValue) != 0)
{
sql += " AND GBStatusID=" + SysString.ToDBString(SysConvert.ToInt32(drpGBStatusID.EditValue));
}
DataTable dt = SysUtils.Fill(sql);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 获得单据号码
/// </summary>
/// <param name="p_FormNoID">单据ID</param>
private string RGetWHFormNo(int p_FormListID, string p_WHID)
{
try
{
string sql = "SELECT FormNoControlID FROM Enum_FormList WHERE ID=" + SysString.ToDBString(p_FormListID);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
return(this.RGetFormNo(SysConvert.ToInt32(dt.Rows[0]["FormNoControlID"].ToString()), 0, p_WHID));
}
return("");
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 显示未归还数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RLShow(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV1_Dev_GBJCLRDts WHERE 1=1 AND GBStatusID=2";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
private void SetGridViewItemTest(DataTable p_dt)
{
foreach (DataRow dr in p_dt.Rows)
{
string sql = "SELECT FormNo FROM Att_ItemTestForm WHERE ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
string FormNoStr = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (FormNoStr != "")
{
FormNoStr += ",";
}
FormNoStr += SysConvert.ToString(dt.Rows[i][0]);
}
dr["ItemTest"] = FormNoStr;
}
}
}
private void setYarn(string str)
{
int setRowID = Common.GetNewRow(gridView1, "ItemCode");
string[] gbid = str.Split(',');
for (int i = 0; i < gbid.Length; i++)
{
string sql = "SELECT * FROM Data_Item WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(gbid[i]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
gridView1.SetRowCellValue(setRowID, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(setRowID, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(setRowID, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(setRowID, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
gridView1.SetRowCellValue(setRowID, "Unit", SysConvert.ToString(dt.Rows[0]["ItemUnit"]));
setRowID++;
}
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShow(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM Data_OPAuthGrp WHERE 1=1";
sql += p_condition;
return SysUtils.Fill(sql);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
public static string ProcCondition(string p_TableName, string p_CLSA, string p_CLSB)
{
m_ColorIniFlag = false;
string sql = "Select * FROM Data_FormDeviation WHERE DTableName=" + SysString.ToDBString(p_TableName);
if (p_CLSA != string.Empty)
{
sql += " AND CLSA=" + SysString.ToDBString(p_CLSA);
}
if (p_CLSB != string.Empty)
{
sql += " AND CLSB=" + SysString.ToDBString(p_CLSB);
}
dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
condition = SysConvert.ToString(dt.Rows[0]["DeviationID"]);
}
return(condition);
}
private void setItemNews(string p_Str)
{
string[] orderid = p_Str.Split(',');
string sql = "SELECT * FROM UV1_Dev_Sample WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[0]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
txtOrderFormNo.Text = SysConvert.ToString(dt.Rows[0]["SO"]);//合同号
//txtCPItemCode.Text = SysConvert.ToString(dt.Rows[0]["CPItemCode"]);
txtCPItemModel.Text = SysConvert.ToString(dt.Rows[0]["CPItemCode"]);
txtCPItemName.Text = SysConvert.ToString(dt.Rows[0]["CPItemName"]);
txtCPItemStd.Text = SysConvert.ToString(dt.Rows[0]["CPItemStd"]);
txtCPDensity.Text = SysConvert.ToString(dt.Rows[0]["CPDensity"]);
txtCPMWidth.Text = SysConvert.ToString(dt.Rows[0]["CPMWidth"]);
txtCPMWeight.Text = SysConvert.ToString(dt.Rows[0]["CPMWeight"]);
txtLightSource.Text = SysConvert.ToString(dt.Rows[0]["LightSource"]); //对色光源
drpFactoryID2.EditValue = SysConvert.ToString(dt.Rows[0]["FactoryID3"]); //染厂
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShow(int p_ID, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM WH_IOFormDts WHERE 1=1";
sql += " AND MainID=" + p_ID;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShow(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM Sale_JYOrderDtsInputPack WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable UvRShow(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV1_Enum_FormList WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
private void drpBJHB_EditValueChanged(object sender, EventArgs e)
{
try
{
string sql = "";
string pName = drpBJHB.Text.Trim();
if (drpBJHB.Text != string.Empty)
{
sql = "SELECT Rate FROM Data_Currency WHERE Name=" + SysString.ToDBString(pName);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
txtBJHL.Text = dt.Rows[0]["Rate"].ToString();
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShow2(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV2_Finance_CheckOperationDts2 WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShow(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM WO_BProductCheckDtsModifyLog WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// 获得查询结果集方法
/// </summary>
/// <param name="p_Sql"></param>
/// <returns></returns>
public string GetReustGrid(string p_Sql, out GridView o_View)
{
string outstr = string.Empty;
o_View = new GridView();
DevExpress.XtraGrid.GridControl gridCtl = new DevExpress.XtraGrid.GridControl();
gridCtl.MainView = o_View;
gridCtl.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { o_View });
this.Controls.Add(gridCtl);
o_View.GridControl = gridCtl;
DataTable dt = SysUtils.Fill(p_Sql);
o_View.GridControl.DataSource = dt;
o_View.GridControl.Show();
gridCtl.Visible = false;
if (dt.Rows.Count != 0)
{
outstr = dt.Rows[0][0].ToString();
}
return(outstr);
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShowView(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV1_Sale_SaleOrderTFabricCompSite WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShowDts(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV1_Data_FlowerTypeContol WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
/// <summary>
///绑定Data_Item，显示物品信息
/// </summary>
/// <param name="p_DrpID">SearchLookUpEdit控件</param>
public static void BindItem(SearchLookUpEdit p_DrpID, int[] p_ItemType)
{
string sql = "SELECT ItemCode,ItemName,ItemStd FROM Data_Item WHERE 1=1";
if (p_ItemType.Length > 0)
{
sql += " AND ItemTypeID IN(" + Common.ConvertArrayIntToStr(p_ItemType) + ")";
}
sql += " ORDER BY ItemCode";
DataTable dt = SysUtils.Fill(sql);
LoadSearch(p_DrpID, dt, "ItemCode", "ItemCode", string.Empty);
SetSLKGrid(p_DrpID.Properties.View, new string[3] {
"ItemCode", "ItemName", "ItemStd"
}, new string[3] {
"物品编码", "物品名称", "物品规格"
}, new bool[3] {
true, true, true
});
}
/// <summary>
/// 显示数据
/// </summary>
/// <param name="p_condition"></param>
public DataTable RShowIOFormDts(string p_condition, string p_FieldName)
{
try
{
if (p_FieldName == string.Empty)
{
p_FieldName = "*";
}
string sql = "SELECT " + p_FieldName + " FROM UV1_CaiWu_CWDuiZhangIOFormDts WHERE 1=1";
sql += p_condition;
return(SysUtils.Fill(sql));
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
private void setItemNews(string str)
{
string[] gbid = str.Split(',');
for (int i = 0; i < gbid.Length; i++)
{
string sql = "SELECT * FROM Data_Item WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(gbid[i]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "MWidth", SysConvert.ToDecimal(dt.Rows[0]["MWidth"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "MWeight", SysConvert.ToDecimal(dt.Rows[0]["MWeight"]));
//gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "WeightUnit", SysConvert.ToString(dt.Rows[0]["WeightUnit"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
//gridView1.SetRowCellValue(gridView1.FocusedRowHandle + i, "Unit", SysConvert.ToString(dt.Rows[0]["ItemUnit"]));
}
}
}
private void gridViewRowChanged2(object sender)
{
try
{
BaseFocusLabel.Focus();
ColumnView view = sender as ColumnView;
if (view.FocusedRowHandle >= 0)
{
int ID = SysConvert.ToInt32(view.GetRowCellValue(view.FocusedRowHandle, "ID"));
string sql = string.Empty;
sql = "SELECT ID,SubSeq,0 SelectFlag,BoxNo,Qty,'' ItemModel,'' JarNum FROM WH_IOFormDtsPack WHERE DID= " + SysString.ToDBString(ID);
DataTable dt = SysUtils.Fill(sql);
BindUCFabView(dt);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void btnGet_Click(object sender, EventArgs e)
{
try
{
string tableName = txtTable.Text.Trim();
string sql = "SELECT * FROM " + tableName;
string sqlTotal = string.Empty;
DataTable dt = SysUtils.Fill(sql);
int count = dt.Columns.Count;
foreach (DataRow dr in dt.Rows)
{
string Column = string.Empty;
string Name = string.Empty;
for (int i = 0; i < count - 1; i++)
{
if (Column != string.Empty)
{
Column += ",";
}
Column += dt.Columns[i].ColumnName;
if (Name != string.Empty)
{
Name += ",";
}
Name += SysString.ToDBString(SysConvert.ToString(dr[i]));
}
string insert = "INSERT " + tableName + "(" + Column + ")VALUES(" + Name + ")";
if (sqlTotal != string.Empty)
{
sqlTotal += " \r\n";
}
sqlTotal += insert;
}
txtSql.Text = sqlTotal;
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
public override void gridViewRowChanged1(object sender)
{
try
{
base.gridViewRowChanged1(sender);
ColumnView view = sender as ColumnView;
Item entity = new Item();
entity.ID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID"));
entity.SelectByID();
txtPBPrice.Text = SysConvert.ToString(entity.PBPrice);
txtColorPrice.Text = SysConvert.ToString(entity.ColorPrice);
txtZLPrice.Text = SysConvert.ToString(entity.ZLPrice);
txtShrinkage.Text = SysConvert.ToString(entity.Shrinkage);
TotalPriceUSB.Text = SysConvert.ToString(entity.TotalPriceUSB);
TotalPriceRMB.Text = SysConvert.ToString(entity.TotalPriceRMB);
txtExchangeRate.Text = SysConvert.ToString(entity.ExchangeRate);
txtCBPrice.Text = SysConvert.ToString(entity.CBPrice);
txtRemark.Text = SysConvert.ToString(entity.Remark);
BindGridHis(SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID")), SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ColorNum")));
string ItemCode = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ItemCode"));
string ColorNum = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorNum"));
string ColorName = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorName"));
string sql = "SELECT * FROM UV1_Sale_QuotedPriceDts WHERE ItemCode=" + SysString.ToDBString(ItemCode);
//sql += " AND ColorNum=" + SysString.ToDBString(ColorNum);
//sql += " AND ColorName=" + SysString.ToDBString(ColorName);
sql += " ORDER BY MakeDate DESC";
DataTable dt = SysUtils.Fill(sql);
gridView3.GridControl.DataSource = dt;
gridView3.GridControl.Show();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载库存信息
/// </summary>
/// <param name="p_Str"></param>
private void SetWH(string p_Str)
{
int setRowID = gridView1.FocusedRowHandle;//设置数据行号
string[] itembuyid = p_Str.Split(',');
for (int i = 0; i < itembuyid.Length; i++)
{
string sql = "SELECT * FROM UV1_WH_Storge WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(itembuyid[i]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 1)
{
gridView1.SetRowCellValue(setRowID, "SectionID", SysConvert.ToString(dt.Rows[0]["SectionID"]));
gridView1.SetRowCellValue(setRowID, "SBitID", SysConvert.ToString(dt.Rows[0]["SBitID"]));
gridView1.SetRowCellValue(setRowID, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(setRowID, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(setRowID, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
gridView1.SetRowCellValue(setRowID, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"]));
gridView1.SetRowCellValue(setRowID, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"]));
gridView1.SetRowCellValue(setRowID, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
gridView1.SetRowCellValue(setRowID, "DLCode", SysConvert.ToString(dt.Rows[0]["MLDLCode"]));
gridView1.SetRowCellValue(setRowID, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(setRowID, "Qty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]));
gridView1.SetRowCellValue(setRowID, "VColorNum", SysConvert.ToString(dt.Rows[0]["VColorNum"]));
gridView1.SetRowCellValue(setRowID, "VColorName", SysConvert.ToString(dt.Rows[0]["VColorName"]));
gridView1.SetRowCellValue(setRowID, "VItemCode", SysConvert.ToString(dt.Rows[0]["VItemCode"]));
gridView1.SetRowCellValue(setRowID, "MWidth", SysConvert.ToDecimal(dt.Rows[0]["MWidth"]));
gridView1.SetRowCellValue(setRowID, "MWeight", SysConvert.ToDecimal(dt.Rows[0]["MWeight"]));
gridView1.SetRowCellValue(setRowID, "WeightUnit", SysConvert.ToString(dt.Rows[0]["WeightUnit"]));
gridView1.SetRowCellValue(setRowID, "GoodsLevel", SysConvert.ToString(dt.Rows[0]["GoodsLevel"]));
gridView1.SetRowCellValue(setRowID, "Batch", SysConvert.ToString(dt.Rows[0]["Batch"]));
gridView1.SetRowCellValue(setRowID, "VendorBatch", SysConvert.ToString(dt.Rows[0]["VendorBatch"]));
gridView1.SetRowCellValue(setRowID, "DtsInVendorID", SysConvert.ToString(dt.Rows[0]["VendorID"]));
gridView1.SetRowCellValue(setRowID, "InSO", SysConvert.ToString(dt.Rows[0]["SO"]));
gridView1.SetRowCellValue(setRowID, "InOrderFormNo", SysConvert.ToString(dt.Rows[0]["OrderFormNo"]));
gridView1.SetRowCellValue(setRowID, "InSaleOPID", SysConvert.ToString(dt.Rows[0]["DutyOPID"]));
setRowID++;
}
}
}
/// <summary>
/// 自动更新
/// </summary>
private static void CheckAutoUpdate(out bool outflag)
{
if (!FCommon.SetDBFirst())//设置数据库连接串
{
//设置没有通过[检测是否没有读取到数据库服务器]
MessageBox.Show("数据库连接失败");
frmSetDB frm = new frmSetDB();
frm.ShowDialog();
}
//if (FParamConfig.DBConnFlag == false)//判断数据库是否连接上了
//{
// frmSetDB frm = new frmSetDB();
// frm.ShowDialog();
//}
outflag = false;
if (FParamConfig.DBConnFlag)
{
string sql = "SELECT TOP 1 Version FROM Sys_Version WHERE AllowFlag='1' ORDER BY ReleaseDate DESC";//查找最新的版本
System.Data.DataTable dt = SysUtils.Fill(sql);
string lastversion = string.Empty;
if (dt.Rows.Count != 0)
{
lastversion = dt.Rows[0][0].ToString().ToUpper();//找出最新版程序
}
if (FParamConfig.Version.ToUpper() != lastversion)
{
string StrExe = Application.StartupPath + @"\AutoUpdate.exe";
if (System.IO.File.Exists(StrExe))
{
outflag = true;
System.Diagnostics.Process.Start(StrExe);
}
}
}
}