private void button2_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
string salespeople = SQLDatabase.NowUserID;
if (SQLDatabase.CheckHaveRight(salespeople, "设置客户期初应收"))
{
this.getOrderWzbhByBussCodeAllTableAdapter.Fill(this.lYSalseMange.GetOrderWzbhByBussCodeAll, this.dateTimePicker1.Value
, this.dateTimePicker2.Value.AddDays(1), "");
}
else if (SQLDatabase.CheckHaveRight(salespeople, "查看客户期初应收"))
{
this.getOrderWzbhByBussCodeAllTableAdapter.Fill(this.lYSalseMange.GetOrderWzbhByBussCodeAll, this.dateTimePicker1.Value
, this.dateTimePicker2.Value.AddDays(1), "");
}
else
{
this.getOrderWzbhByBussCodeAllTableAdapter.Fill(this.lYSalseMange.GetOrderWzbhByBussCodeAll, this.dateTimePicker1.Value
, this.dateTimePicker2.Value.AddDays(1), salespeople);
}
NewFrm.Hide(this);
}
private void 打印PToolStripButton_Click(object sender, EventArgs e)
{
if (null == this.ly_store_innum_purchaseDataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);;
//this.ly_plan_getmaterialTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial, parentId);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密电装入库单";
queryForm.Printdata = this.lYStoreMange;
queryForm.PrintCrystalReport = new LY_ProductRukudan();
//string selectFormula;
//selectFormula = "{ly_store_planitemcount.状态} = '原料' and {ly_store_planitemcount.欠料金额}>0 ";
//queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void RecoverPlanStruSingle(string planNum, string itemnum)
{
NewFrm.Show(this);
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@planNum", SqlDbType.VarChar);
cmd.Parameters["@planNum"].Value = planNum;
cmd.Parameters.Add("@itemNum", SqlDbType.VarChar);
cmd.Parameters["@itemNum"].Value = itemnum;
cmd.CommandText = "LY_Record_Plan_single";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
cmd.CommandTimeout = 0;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
//ly_material_plan_explodeTableAdapter.Fill(this.lYPlanMange.ly_material_plan_explode, parentId);
//this.ly_store_planitemcountTableAdapter.Fill(this.lYPlanMange.ly_store_planitemcount, parentId);
//this.ly_plan_getmaterial_departmentTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial_department, planNum);
NewFrm.Hide(this);
}
private void toolStripButton31_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
Thread.Sleep(500);
this.ly_wip_viewTableAdapter.Fill(this.lYStoreMange.ly_wip_view, dateTimePicker7.Value, dateTimePicker8.Value.AddDays(1));
NewFrm.Hide(this);
}
private void LY_MaterialMange_Load(object sender, EventArgs e)
{
this.tabPage2.Parent = null;
this.tabPage6.Parent = null;
SetHavePricerIGHT();
NewFrm.Show(this);
this.f_Item_dynamicpriceTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring;
this.ly_plan_getmaterialTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring;
this.ly_waste_in_ylTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring;
this.ly_waste_outqueryTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring;
this.lY_InventoryWaste_queryTableAdapter.Connection.ConnectionString = SQLDatabase.Connectstring;
this.lY_InventoryWaste_queryTableAdapter.Fill(this.lYStoreMange.LY_InventoryWaste_query, SQLDatabase.NowUserID);
SetRowBackground();
SetRowBackground();
NewFrm.Hide(this);
}
private void 计算当前物料成本ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (null == this.ly_inma0010DataGridView.CurrentRow)
{
return;
}
string nowplannum;
string noename;
NewFrm.Show(this);
nowplannum = this.ly_inma0010DataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
noename = this.ly_inma0010DataGridView.CurrentRow.Cells["名称"].Value.ToString();
//this.toolStripLabel3.Text = plannum;
//this.toolStripLabel3.Invalidate();
NewFrm.Notify(this, "正在计算: (" + nowplannum + ")" + noename + " 成本");
Countmoney(nowplannum);
NewFrm.Hide(this);
this.ly_inma0010cpTableAdapter.Fill(this.lYMaterialMange.ly_inma0010cp);
this.ly_inma0010cpBindingSource.Position = this.ly_inma0010cpBindingSource.Find("物资编号", nowplannum);
}
private void toolStripButton5_Click(object sender, EventArgs e)
{
if (null == this.ly_production_submit_periodDataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);;
BaseReportView queryForm = new BaseReportView();
queryForm.setchackBoxCansee(false);
queryForm.Printdata = this.lYProductMange;
queryForm.Text = "中原精密生产报表";
queryForm.PrintCrystalReport = new LY_ProductReport_period();
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
if (null == this.ly_inma0010DataGridView.CurrentRow)
{
return;
}
string nowplannum;
string noename;
NewFrm.Show(this);
foreach (DataGridViewRow dgr in ly_inma0010DataGridView.Rows)
{
nowplannum = dgr.Cells["物资编号"].Value.ToString();
noename = dgr.Cells["名称"].Value.ToString();
//this.toolStripLabel3.Text = plannum;
//this.toolStripLabel3.Invalidate();
NewFrm.Notify(this, "正在计算: (" + nowplannum + ") " + noename + " 成本");
Countmoney(nowplannum);
}
NewFrm.Hide(this);
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
if (null == this.ly_store_innum_purchaseDataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);;
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密异型返库出入库单";
queryForm.Printdata = this.lYSalseMange2;
queryForm.PrintCrystalReport = new LY_Yixingchuruku();
//string selectFormula;
//selectFormula = "{ly_store_planitemcount.状态} = '原料' and {ly_store_planitemcount.欠料金额}>0 ";
//queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void 打印PToolStripButton_Click(object sender, EventArgs e)
{
if (null == this.ly_production_orderDataGridView.CurrentRow)
{
return;
}
//string balanceFlag = this.xD_Sel_SellBalanceDataGridView.CurrentRow.Cells["结算"].Value.ToString();
NewFrm.Show(this);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "钳装生产任务领料单";
queryForm.Printdata = this.lYProductMange;
queryForm.PrintCrystalReport = new LY_ProductTaskReport();
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void 装箱单打印总表ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (null == this.ly_sales_deliver_detailDataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);;
//this.ly_plan_getmaterialTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial, parentId);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密营业发货装箱单";
queryForm.Printdata = this.lYSalseMange;
queryForm.PrintCrystalReport = new LY_YingyeHetong_FHZX2();
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void toolStripButton27_Click(object sender, EventArgs e)
{
if (null == this.ly_stocktake_detailDataGridView.CurrentRow)
{
return;
}
//if ("" == ly_sales_contract_mainDataGridView.CurrentRow.Cells["类别"].Value.ToString())
//{
// MessageBox.Show("请选择合同类别,然后打印...", "注意");
// return;
//}
NewFrm.Show(this);;
//this.ly_plan_getmaterialTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial, parentId);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密盘点报表";
queryForm.Printdata = this.lYStoreMange;
queryForm.PrintCrystalReport = new LY_InventoryRepore();
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void SaveChenged()
{
this.ly_stocktake_mainDataGridView.EndEdit();
this.ly_stocktake_mainBindingSource.EndEdit();
//if (false == this.Validate()) return;
if (checkInput())
{
//frmWaiting.Show(this);
NewFrm.Show(this);
NewFrm.Notify(this, "正在生成盘点数据，请等待...");
this.ly_stocktake_mainTableAdapter.CommandTimeout = 0;
this.ly_stocktake_mainTableAdapter.Update(this.lYStoreMange.ly_stocktake_main);
//frmWaiting.Hide(this);
NewFrm.Hide(this);
//this.hT_Maintenance_ItemTableAdapter.Fill(this.hT_Insurance.HT_Maintenance_Item, loanId);
this.SetFormState("View");
}
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
if (null == this.ly_plan_getmaterialDataGridView.CurrentRow)
{
return;
}
int parentId = int.Parse(this.ly_material_plan_mainDataGridView.CurrentRow.Cells["id"].Value.ToString());
NewFrm.Show(this);
//this.ly_plan_getmaterialTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial, parentId);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密临时配套表";
queryForm.Printdata = this.lYPlanMange;
queryForm.PrintCrystalReport = new LY_PlanTemp();
//string selectFormula;
//selectFormula = "{ly_store_planitemcount.状态} = '原料' and {ly_store_planitemcount.欠料金额}>0 ";
//queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
protected void loadData()
{
string nowdatestyle;
if (this.radioButton1.Checked)
{
nowdatestyle = "录入";
}
else
{
nowdatestyle = "锁定";
}
NewFrm.Show(this);
this.ly_invoiceTableAdapter.Fill(this.lYMaterielRequirements.ly_invoice, DateTime.Parse(this.dateTimePicker1.Text).Date, DateTime.Parse(this.dateTimePicker2.Text).Date, nowdatestyle);
if (SQLDatabase.CheckHaveRight(SQLDatabase.NowUserID, "发票总管理权限"))
{
if ("0002" == SQLDatabase.nowUserDepartmentBig())
{
this.lyinvoiceBindingSource.Filter = "submit=True";
}
}
else
{
string salespeople = SQLDatabase.nowUserName();
lyinvoiceBindingSource.Filter = "sava_people='" + salespeople + "'";
}
NewFrm.Hide(this);
}
private void 打印PToolStripButton_Click(object sender, EventArgs e)
{
if (null == this.ly_store_outDataGridView.CurrentRow)
{
return;
}
string out_number = this.ly_store_outDataGridView.CurrentRow.Cells["out_number"].Value.ToString();
NewFrm.Show(this);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密生产领料单";
queryForm.Printdata = this.lYStoreMange;
queryForm.PrintCrystalReport = new LY_Lingliaodan_Tool();
string selectFormula;
selectFormula = "{ly_store_out_tool.out_number} = '" + out_number + "' ";
queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void 打印PToolStripButton_Click(object sender, EventArgs e)
{
if (null == this.ly_store_in_JGDataGridView.CurrentRow)
{
return;
}
string Rkd = this.ly_store_in_JGDataGridView.CurrentRow.Cells["入库单号"].Value.ToString();
NewFrm.Show(this);;
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密机加入库单";
queryForm.Printdata = this.lYQualityInspector;
queryForm.PrintCrystalReport = new LY_WaixieRukudanJG();
string selectFormula;
selectFormula = "{ly_store_in_JG.入库单号} = '" + Rkd + "'";
queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void toolStripButton7_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.ly_item_allcost_NoVatTableAdapter.Fill(this.lYMaterialMange.ly_item_allcost_NoVat, this.parentNum);
NewFrm.Hide(this);
}
private void toolStripButton12_Click(object sender, EventArgs e)
{
if (null == this.ly_purchase_contract_detailDataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);;
//this.ly_plan_getmaterialTableAdapter.Fill(this.lYPlanMange.ly_plan_getmaterial, parentId);
BaseReportView queryForm = new BaseReportView();
queryForm.Text = "中原精密采购合同";
queryForm.Printdata = this.lYMaterielRequirements;
queryForm.PrintCrystalReport = new LY_WaixiePurchaseHetong();
//string selectFormula;
//selectFormula = "{ly_store_planitemcount.状态} = '原料' and {ly_store_planitemcount.欠料金额}>0 ";
//queryForm.PrintCrystalReport.DataDefinition.RecordSelectionFormula = selectFormula;
NewFrm.Hide(this);
queryForm.ShowDialog();
}
private void ly_inma0010DataGridView_MouseDoubleClick(object sender, MouseEventArgs e)
{
if (null == ly_inma0010DataGridView.CurrentRow)
{
return;
}
NewFrm.Show(this);
string s = this.ly_inma0010DataGridView.CurrentRow.Cells["物资编号"].Value.ToString();
this.ly_sales_matingBom_CostTableAdapter.Fill(this.lYMaterialMange.ly_sales_matingBom_Cost, s);
string selAllString = "SELECT parentno, itemno, cast(itemno +':'+itemname as char(30)) as itemname,cast(qty_set as decimal(18,3)) as qty_set,itemprice ,itemmoney,assemblymoney,standardsetmoney,itemprocessingmoney,operation_cost,isnull(itemmoney,0)+isnull(itemprocessingmoney,0)+isnull(assemblymoney,0)+isnull(standardsetmoney,0)+isnull(operation_cost,0) as allmoney from f_BomExtend_price('" + s + "',1) ORDER BY id_num ";
string cString = SQLDatabase.Connectstring;;
SqlDataAdapter bomAdapter = new SqlDataAdapter(selAllString, cString);
bomAdapter.SelectCommand.CommandTimeout = 0;
DataSet bomData = new DataSet();
bomAdapter.Fill(bomData);
this.treeView1.Nodes.Clear();
MakeTreeView(bomData.Tables[0], null, null);
//this.treeView1.ExpandAll();
this.treeView1.SelectedNode = this.treeView1.Nodes[0];
this.treeView1.SelectedNode.Expand();
this.groupBox1.Text = s + "BOM结构图";
NewFrm.Hide(this);
}
private void toolStripButton22_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.ly_material_task_viewNewTableAdapter.Fill(this.lYPlanMange.ly_material_task_viewNew);
AddSummationRow_New(ly_material_task_viewNewBindingSource, ly_material_task_viewNewDataGridView);
NewFrm.Hide(this);
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
TableForSumWeek("FromCal");
NewFrm.Hide(this);
}
private void button1_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.ly_sales_test_detail1TableAdapter.Fill(this.lYSalseMange.ly_sales_test_detail1, DateTime.Parse(this.dateTimePicker1.Text).Date, DateTime.Parse(this.dateTimePicker2.Text).Date);
NewFrm.Hide(this);
}
private void toolStripButton22_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
Thread.Sleep(100);
this.ly_production_submit_periodTableAdapter.Fill(this.lYProductMange.ly_production_submit_period, this.dateTimePicker5.Value, this.dateTimePicker6.Value.AddDays(1));
this.ly_production_detail_viewTableAdapter.Fill(this.lYProductMange.ly_production_detail_view, this.dateTimePicker5.Value, this.dateTimePicker6.Value.AddDays(1));
NewFrm.Hide(this);
}
private void button3_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.getOrderByBussCodeAll_ByOutTableAdapter.Fill(this.lYSalseMange.GetOrderByBussCodeAll_ByOut, this.dateTimePicker3.Value
, this.dateTimePicker4.Value.AddDays(1));
AddSummationRow_New2(getOrderByBussCodeAllByOutBindingSource, dataGridView2);
NewFrm.Hide(this);
}
private void toolStripButton6_Click(object sender, EventArgs e)
{
if (null == this.ly_inma0010DataGridView.CurrentRow)
{
return;
}
string nowplannum;
string noename;
NewFrm.Show(this);
foreach (DataGridViewRow dgr in ly_inma0010DataGridView.Rows)
{
nowplannum = dgr.Cells["物资编号"].Value.ToString();
noename = dgr.Cells["名称"].Value.ToString();
//this.toolStripLabel3.Text = plannum;
//this.toolStripLabel3.Invalidate();
NewFrm.Notify(this, "正在计算: (" + nowplannum + ")" + noename + " 成本");
Countmoney(nowplannum);
}
NewFrm.Hide(this);
this.ly_inma0010cpTableAdapter.Fill(this.lYMaterialMange.ly_inma0010cp);
///////////////////////
// string insStr = " INSERT INTO ly_bm0031 " +
// "( parent,component) " +
// " values ('" + parentNum + "','" + componentNum + "' )";
// using (TransactionScope scope = new TransactionScope())
// {
// SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
// SqlCommand cmd = new SqlCommand();
// cmd.CommandText = insStr;
// cmd.CommandType = CommandType.Text;
// cmd.Connection = sqlConnection1;
// sqlConnection1.Open();
// cmd.ExecuteNonQuery();
// sqlConnection1.Close();
// scope.Complete();
// }
//}
}
private void button2_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.lY_Invoice_storeInAllTableAdapter.Fill(this.lYQualityInspector.LY_Invoice_storeInAll, DateTime.Parse(this.dateTimePicker3.Text).Date, DateTime.Parse(this.dateTimePicker4.Text).Date.AddDays(1));
AddSummationRow_New(lYInvoicestoreInAllBindingSource, dataGridView1);
NewFrm.Hide(this);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.lY_Inventory_queryClassTableAdapter.Fill(this.lYStoreMange.LY_Inventory_queryClass, this.nowsortcode);
CountMoney(lY_Inventory_queryClassBindingSource, ly_inma0010DataGridView);
NewFrm.Hide(this);
}
private void MakeSalesContract(string clientcode, string billcode)
{
SqlConnection sqlConnection1 = new SqlConnection(SQLDatabase.Connectstring);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@salesclient_code", SqlDbType.VarChar);
cmd.Parameters["@salesclient_code"].Value = clientcode;
cmd.Parameters.Add("@contract_inner_code", SqlDbType.VarChar);
cmd.Parameters["@contract_inner_code"].Value = billcode;
//cmd.Parameters.Add("@warehousename", SqlDbType.VarChar);
//cmd.Parameters["@warehousename"].Value = comboBox2.SelectedValue;
//string outNum = GetMaxOutNum();
//cmd.Parameters.Add("@out_number", SqlDbType.VarChar);
//cmd.Parameters["@out_number"].Value = outNum;
//cmd.Parameters.Add("@inputman", SqlDbType.VarChar);
//cmd.Parameters["@inputman"].Value = SQLDatabase.nowUserName();
//cmd.Parameters.Add("@innercode", SqlDbType.VarChar);
//cmd.Parameters["@innercode"].Value = innerCode;
cmd.CommandText = "LY_return_to_contract";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
try
{
NewFrm.Show(this);
Thread.Sleep(100);
cmd.ExecuteNonQuery();
NewFrm.Hide(this);
MessageBox.Show("导出成功,请补充合同相关数据", "注意");
}
catch (SqlException sqle)
{
MessageBox.Show("导出失败,请检验相关数据", "注意");
NewFrm.Hide(this);
}
finally
{
sqlConnection1.Close();
}
}
private void toolStripButton53_Click(object sender, EventArgs e)
{
NewFrm.Show(this);
this.ly_purchase_contract_main11TableAdapter.Fill(this.lYMaterielRequirements.ly_purchase_contract_main11, this.dateTimePicker1.Value, this.dateTimePicker2.Value.AddDays(1));
AddSummationRow_New(ly_purchase_contract_main11BindingSource, ly_purchase_contract_mainDataGridView);
NewFrm.Hide(this);
}