/// <summary>
/// 写数据到241中
/// </summary>
/// <param name="modelAm"></param>
/// <returns></returns>
public bool UpdateOfRecevable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
if (modelAm.AM108 > 0)
{
StringBuilder strSqlAM108 = new StringBuilder( );
strSqlAM108.AppendFormat("UPDATE R_PQAM SET AM108='{0}' WHERE AM002='{1}'", modelAm.AM108, modelAm.AM002);
SQLString.Add(strSqlAM108.ToString( ));
}
if (modelAm.AM110 > 0)
{
StringBuilder strSqlAM110 = new StringBuilder( );
strSqlAM110.AppendFormat("UPDATE R_PQAM SET AM110='{0}' WHERE AM002='{1}'", modelAm.AM110, modelAm.AM002);
SQLString.Add(strSqlAM110.ToString( ));
}
if (modelAm.AM111 > 0)
{
StringBuilder strSqlAM111 = new StringBuilder( );
strSqlAM111.AppendFormat("UPDATE R_PQAM SET AM111='{0}' WHERE AM002='{1}'", modelAm.AM111, modelAm.AM002);
SQLString.Add(strSqlAM111.ToString( ));
}
if (modelAm.AM115 > 0)
{
StringBuilder strSqlAM115 = new StringBuilder( );
strSqlAM115.AppendFormat("UPDATE R_PQAM SET AM115='{0}' WHERE AM002='{1}'", modelAm.AM115, modelAm.AM002);
SQLString.Add(strSqlAM115.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 写数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool UpdateOfRece(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
//WriteReceivableToGeneralLedger.ByOneByWu( modelAm ,oddNum ,SQLString );
StringBuilder strSql = new StringBuilder( );
if (modelAm.AM209 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM209='{0}' WHERE AM002='{1}'", modelAm.AM209, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM211 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM211='{0}' WHERE AM002='{1}'", modelAm.AM211, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM225 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM225='{0}' WHERE AM002='{1}'", modelAm.AM225, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM227 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM227='{0}' WHERE AM002='{1}'", modelAm.AM227, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
private void ProductPackageMaterialAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox151.Text = model.AM136.ToString( );
textBox150.Text = model.AM137.ToString( );
textBox149.Text = model.AM138.ToString( );
textBox1.Text = model.AM141.ToString( );
textBox157.Text = model.AM139.ToString( );
textBox156.Text = model.AM140.ToString( );
textBox155.Text = model.AM144.ToString( );
textBox2.Text = model.AM147.ToString( );
textBox160.Text = model.AM142.ToString( );
textBox159.Text = model.AM143.ToString( );
textBox158.Text = model.AM150.ToString( );
textBox3.Text = model.AM135.ToString( );
textBox163.Text = model.AM145.ToString( );
textBox162.Text = model.AM146.ToString( );
textBox161.Text = model.AM133.ToString( );
textBox4.Text = model.AM134.ToString( );
textBox166.Text = model.AM148.ToString( );
textBox165.Text = model.AM149.ToString( );
textBox164.Text = model.AM130.ToString( );
textBox5.Text = model.AM131.ToString( );
}
void ByOneBy ( MulaolaoLibrary.ProductCostSummaryLibrary modelAm ,string oddNum ,ArrayList SQLString )
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat( "SELECT AMB088 FROM R_PQAMB WHERE AMB001='{0}'" ,oddNum );
DataTable de = SqlHelper.ExecuteDataTable( "SELECT AM088 FROM R_PQAM WHERE AM002='" + modelAm.AM002 + "'" );
DataTable da = SqlHelper.ExecuteDataTable( strSql.ToString( ) );
if ( da != null && da.Rows.Count > 0 )
{
if ( modelAm.AM088 > 0 )
{
strSql = new StringBuilder( );
strSql.AppendFormat( "UPDATE R_PQAMB SET AMB088='{0}' WHERE AMB001='{1}'" ,modelAm.AM088 ,oddNum );
SQLString.Add( strSql.ToString( ) );
}
if ( de != null && de.Rows.Count > 0 )
{
modelAm.AM088 = modelAm.AM088 - ( string.IsNullOrEmpty( da.Rows[0]["AMB088"].ToString( ) ) == true ? 0 : Convert.ToDecimal( da.Rows[0]["AMB088"].ToString( ) ) );
modelAm.AM088 = modelAm.AM088 + ( string.IsNullOrEmpty( da.Rows[0]["AMB088"].ToString( ) ) == true ? 0 : Convert.ToDecimal( da.Rows[0]["AMB088"].ToString( ) ) );
}
}
else
{
strSql = new StringBuilder( );
strSql.AppendFormat( "INSERT INTO R_PQAMB (AMB001,AMB088) VALUES ('{0}','{1}')" ,oddNum ,modelAm.AM088 );
SQLString.Add( strSql.ToString( ) );
if ( de != null && de.Rows.Count > 0 )
modelAm.AM088 = modelAm.AM088 + ( string.IsNullOrEmpty( de.Rows[0]["AM088"].ToString( ) ) == true ? 0 : Convert.ToDecimal( de.Rows[0]["AM088"].ToString( ) ) );
}
}
bool WriteOfReceivablesTo( )
{
result = false;
DataTable receiva;
MulaolaoLibrary.ProductCostSummaryLibrary modelAm = new MulaolaoLibrary.ProductCostSummaryLibrary( );
receiva = _bll.GetDataTableOf(_model.PZ001);
if (receiva != null && receiva.Rows.Count > 0)
{
for (int i = 0; i < receiva.Rows.Count; i++)
{
modelAm.AM002 = receiva.Rows[0]["PZ003"].ToString( );
modelAm.AM239 = modelAm.AM241 = 0;
modelAm.AM239 = string.IsNullOrEmpty(receiva.Compute("SUM(PZ)", null).ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("SUM(PZ)", null).ToString( ));
modelAm.AM241 = 0;
if (_bll.UpdateOfReceviable(modelAm, _model.PZ001) == true)
{
result = true;
}
else
{
result = false;
break;
}
}
}
return(result);
}
private void ProductBeforeAndAfterRoadWagesAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox53.Text = model.AM044.ToString( );
textBox52.Text = model.AM045.ToString( );
textBox55.Text = model.AM046.ToString( );
textBox54.Text = model.AM047.ToString( );
textBox57.Text = model.AM048.ToString( );
textBox56.Text = model.AM049.ToString( );
textBox59.Text = model.AM050.ToString( );
textBox58.Text = model.AM051.ToString( );
textBox61.Text = model.AM052.ToString( );
textBox60.Text = model.AM053.ToString( );
textBox63.Text = model.AM054.ToString( );
textBox62.Text = model.AM055.ToString( );
textBox4.Text = model.AM056.ToString( );
textBox3.Text = model.AM057.ToString( );
textBox2.Text = model.AM058.ToString( );
textBox1.Text = model.AM059.ToString( );
textBox6.Text = model.AM060.ToString( );
textBox5.Text = model.AM061.ToString( );
textBox8.Text = model.AM062.ToString( );
textBox7.Text = model.AM063.ToString( );
}
private void ProductContractProcessAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox79.Text = model.AM070.ToString( );
textBox78.Text = model.AM071.ToString( );
textBox84.Text = model.AM072.ToString( );
textBox83.Text = model.AM073.ToString( );
textBox86.Text = model.AM074.ToString( );
textBox85.Text = model.AM075.ToString( );
textBox88.Text = model.AM076.ToString( );
textBox87.Text = model.AM077.ToString( );
textBox90.Text = model.AM078.ToString( );
textBox89.Text = model.AM079.ToString( );
textBox92.Text = model.AM080.ToString( );
textBox91.Text = model.AM081.ToString( );
textBox94.Text = model.AM082.ToString( );
textBox93.Text = model.AM083.ToString( );
textBox96.Text = model.AM084.ToString( );
textBox95.Text = model.AM085.ToString( );
textBox98.Text = model.AM086.ToString( );
textBox97.Text = model.AM087.ToString( );
textBox100.Text = model.AM088.ToString( );
textBox99.Text = model.AM089.ToString( );
textBox102.Text = model.AM090.ToString( );
textBox101.Text = model.AM091.ToString( );
textBox104.Text = model.AM092.ToString( );
textBox103.Text = model.AM093.ToString( );
}
/// <summary>
/// 写数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <returns></returns>
public bool UpdateOfReceivable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
//WriteReceivableToGeneralLedger.ByOneByChe( modelAm ,oddNum ,SQLString );
if (modelAm.AM270 > 0)
{
StringBuilder strSqlAM270 = new StringBuilder( );
strSqlAM270.AppendFormat("UPDATE R_PQAM SET AM270='{0}' WHERE AM002='{1}'", modelAm.AM270, modelAm.AM002);
SQLString.Add(strSqlAM270.ToString( ));
}
if (modelAm.AM272 > 0)
{
StringBuilder strSqlAM272 = new StringBuilder( );
strSqlAM272.AppendFormat("UPDATE R_PQAM SET AM272='{0}' WHERE AM002='{1}'", modelAm.AM272, modelAm.AM002);
SQLString.Add(strSqlAM272.ToString( ));
}
if (modelAm.AM273 > 0)
{
StringBuilder strSqlAM273 = new StringBuilder( );
strSqlAM273.AppendFormat("UPDATE R_PQAM SET AM273='{0}' WHERE AM002='{1}'", modelAm.AM273, modelAm.AM002);
SQLString.Add(strSqlAM273.ToString( ));
}
if (modelAm.AM277 > 0)
{
StringBuilder strSqlAM277 = new StringBuilder( );
strSqlAM277.AppendFormat("UPDATE R_PQAM SET AM277='{0}' WHERE AM002='{1}'", modelAm.AM277, modelAm.AM002);
SQLString.Add(strSqlAM277.ToString( ));
}
if (modelAm.AM279 > 0)
{
StringBuilder strSqlAM279 = new StringBuilder( );
strSqlAM279.AppendFormat("UPDATE R_PQAM SET AM279='{0}' WHERE AM002='{1}'", modelAm.AM279, modelAm.AM002);
SQLString.Add(strSqlAM279.ToString( ));
}
if (modelAm.AM280 > 0)
{
StringBuilder strSqlAM280 = new StringBuilder( );
strSqlAM280.AppendFormat("UPDATE R_PQAM SET AM280='{0}' WHERE AM002='{1}'", modelAm.AM280, modelAm.AM002);
SQLString.Add(strSqlAM280.ToString( ));
}
if (modelAm.AM283 > 0)
{
StringBuilder strSqlAM283 = new StringBuilder( );
strSqlAM283.AppendFormat("UPDATE R_PQAM SET AM283='{0}' WHERE AM002='{1}'", modelAm.AM283, modelAm.AM002);
SQLString.Add(strSqlAM283.ToString( ));
}
if (modelAm.AM285 > 0)
{
StringBuilder strSqlAM285 = new StringBuilder( );
strSqlAM285.AppendFormat("UPDATE R_PQAM SET AM285='{0}' WHERE AM002='{1}'", modelAm.AM285, modelAm.AM002);
SQLString.Add(strSqlAM285.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void WriteOfReceivablesTo( )
{
DataTable receiva;
MulaolaoLibrary.ProductCostSummaryLibrary modelAm = new MulaolaoLibrary.ProductCostSummaryLibrary( );
receiva = bll.GetDataTableOfReceviable(model.IZ001);
if (receiva != null && receiva.Rows.Count > 0)
{
modelAm.AM002 = receiva.Rows[0]["IZ002"].ToString( );
modelAm.AM074 = 0;
modelAm.AM074 = string.IsNullOrEmpty(receiva.Rows[0]["U0"].ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Rows[0]["U0"].ToString( ));
bll.UpdateOfReceivable(modelAm, model.IZ001);
}
}
private void ProductFinishedProductOutsourcingAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox120.Text = model.AM108.ToString( );
textBox119.Text = model.AM109.ToString( );
textBox126.Text = model.AM110.ToString( );
textBox1.Text = model.AM113.ToString( );
textBox125.Text = model.AM111.ToString( );
textBox124.Text = model.AM112.ToString( );
textBox127.Text = model.AM115.ToString( );
textBox2.Text = model.AM116.ToString( );
}
/// <summary>
/// 写数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <returns></returns>
public bool UpdateOfRecevable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
//WriteReceivableToGeneralLedger.ByOneByChanPintZhiBao( modelAm ,oddNum ,SQLString );
if (modelAm.AM173 > 0)
{
StringBuilder strSqlAM173 = new StringBuilder( );
strSqlAM173.AppendFormat("UPDATE R_PQAM SET AM173='{0}' WHERE AM002='{1}'", modelAm.AM173, modelAm.AM002);
SQLString.Add(strSqlAM173.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 写数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool UpdateOfReceivable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
StringBuilder strSql = new StringBuilder( );
if (modelAm.AM074 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM074='{0}' WHERE AM002='{1}'", modelAm.AM074, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
bool WriteOfReceivablesTo( )
{
result = false;
DataTable receiva;
MulaolaoLibrary.ProductCostSummaryLibrary modelAm = new MulaolaoLibrary.ProductCostSummaryLibrary( );
receiva = _bll.GetDataTable(hxp.PQK01);
if (receiva != null && receiva.Rows.Count > 0)
{
modelAm.AM002 = receiva.Rows [0] ["PQK02"].ToString( );
modelAm.AM173 = 0;
modelAm.AM173 = string.IsNullOrEmpty(receiva.Compute("SUM(PQK)", "PQK02='" + modelAm.AM002 + "'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("SUM(PQK)", "PQK02='" + modelAm.AM002 + "'"));
result = _bll.UpdateOfRecevable(modelAm, hxp.PQK01);
}
return(result);
}
private void ProductAgentFeeAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox25.Text = model.AM020.ToString( );
textBox26.Text = model.AM021.ToString( );
textBox28.Text = model.AM022.ToString( );
textBox27.Text = model.AM023.ToString( );
textBox30.Text = model.AM024.ToString( );
textBox29.Text = model.AM025.ToString( );
textBox32.Text = model.AM026.ToString( );
textBox31.Text = model.AM027.ToString( );
textBox34.Text = model.AM028.ToString( );
textBox33.Text = model.AM029.ToString( );
}
private void ProductVehicleWoodPiecesAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox295.Text = model.AM270.ToString( );
textBox294.Text = model.AM271.ToString( );
textBox293.Text = model.AM272.ToString( );
textBox7.Text = model.AM275.ToString( );
textBox301.Text = model.AM273.ToString( );
textBox300.Text = model.AM274.ToString( );
textBox299.Text = model.AM279.ToString( );
textBox8.Text = model.AM282.ToString( );
textBox6.Text = model.AM277.ToString( );
textBox5.Text = model.AM278.ToString( );
textBox3.Text = model.AM280.ToString( );
textBox2.Text = model.AM281.ToString( );
}
void WriteOfReceivablesTo( )
{
DataTable receiva;
MulaolaoLibrary.ProductCostSummaryLibrary modelAm = new MulaolaoLibrary.ProductCostSummaryLibrary( );
receiva = _bll.GetDataTableOfRecevable(_model.BA003);
if (receiva != null && receiva.Rows.Count > 0)
{
for (int i = 0; i < receiva.Rows.Count; i++)
{
modelAm.AM002 = receiva.Rows[i]["BA001"].ToString( );
modelAm.AM108 = modelAm.AM110 = modelAm.AM111 = modelAm.AM115 = 0M;
modelAm.AM108 = string.IsNullOrEmpty(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'F' AND BA056='F'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'F' AND BA056='F'"));
modelAm.AM111 = string.IsNullOrEmpty(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'T' AND BA056='F'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'T' AND BA056='F'"));
modelAm.AM110 = string.IsNullOrEmpty(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'F' AND BA056='T'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'F' AND BA056='T'"));
modelAm.AM115 = string.IsNullOrEmpty(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'T' AND BA056='T'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("sum(BA)", "BA001='" + modelAm.AM002 + "' and BA058= 'T' AND BA056='T'"));
_bll.UpdateOfRecevable(modelAm, _model.BA003);
}
}
}
private void ProductPaintAll_Load ( object sender ,EventArgs e )
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler( Form_MouseDown );
this.MouseMove += new System.Windows.Forms.MouseEventHandler( Form_MouseMove );
this.MouseUp += new System.Windows.Forms.MouseEventHandler( Form_MouseUp );
model = bll.GetModel( id );
textBox193.Text = model.AM175.ToString( );
textBox192.Text = model.AM176.ToString( );
textBox191.Text = model.AM177.ToString( );
textBox13.Text = model.AM180.ToString( );
textBox199.Text = model.AM178.ToString( );
textBox198.Text = model.AM179.ToString( );
textBox197.Text = model.AM184.ToString( );
textBox14.Text = model.AM187.ToString( );
textBox202.Text = model.AM182.ToString( );
textBox201.Text = model.AM183.ToString( );
textBox200.Text = model.AM190.ToString( );
textBox15.Text = model.AM193.ToString( );
textBox205.Text = model.AM185.ToString( );
textBox204.Text = model.AM186.ToString( );
textBox203.Text = model.AM196.ToString( );
textBox16.Text = model.AM199.ToString( );
textBox3.Text = model.AM188.ToString( );
textBox2.Text = model.AM189.ToString( );
textBox1.Text = model.AM200.ToString( );
textBox17.Text = model.AM201.ToString( );
textBox6.Text = model.AM191.ToString( );
textBox5.Text = model.AM192.ToString( );
textBox4.Text = model.AM203.ToString( );
textBox18.Text = model.AM204.ToString( );
textBox9.Text = model.AM194.ToString( );
textBox8.Text = model.AM195.ToString( );
textBox7.Text = model.AM205.ToString( );
textBox19.Text = model.AM206.ToString( );
textBox12.Text = model.AM197.ToString( );
textBox11.Text = model.AM198.ToString( );
textBox10.Text = model.AM207.ToString( );
textBox20.Text = model.AM208.ToString( );
textBox21 . Text = model . AM173 . ToString ( );
}
bool WriteOfReceivablesTo( )
{
result = false;
DataTable receiva;
MulaolaoLibrary.ProductCostSummaryLibrary modelAm = new MulaolaoLibrary.ProductCostSummaryLibrary( );
receiva = _bll.GetDataTableOf241(_model.OZ011);
if (receiva != null && receiva.Rows.Count > 0)
{
for (int i = 0; i < receiva.Rows.Count; i++)
{
modelAm.AM002 = receiva.Rows[i]["OZ001"].ToString( );
modelAm.AM139 = modelAm.AM144 = 0;
modelAm.AM139 = string.IsNullOrEmpty(receiva.Compute("SUM(OZ)", "OZ001='" + modelAm.AM002 + "' AND WX90='F'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("SUM(OZ)", "OZ001='" + modelAm.AM002 + "' AND WX90='F'"));
modelAm.AM144 = string.IsNullOrEmpty(receiva.Compute("SUM(OZ)", "OZ001='" + modelAm.AM002 + "' AND WX90='T'").ToString( )) == true ? 0 : Convert.ToDecimal(receiva.Compute("SUM(OZ)", "OZ001='" + modelAm.AM002 + "' AND WX90='T'"));
result = _bll.UpdateOfReceivable(modelAm, _model.OZ011);
}
}
return(result);
}
private void ProductLron_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox229.Text = model.AM209.ToString( );
textBox228.Text = model.AM210.ToString( );
textBox227.Text = model.AM211.ToString( );
textBox4.Text = model.AM214.ToString( );
textBox235.Text = model.AM212.ToString( );
textBox234.Text = model.AM213.ToString( );
textBox233.Text = model.AM217.ToString( );
textBox5.Text = model.AM220.ToString( );
textBox238.Text = model.AM215.ToString( );
textBox237.Text = model.AM216.ToString( );
textBox236.Text = model.AM221.ToString( );
textBox6.Text = model.AM222.ToString( );
textBox3.Text = model.AM218.ToString( );
textBox2.Text = model.AM219.ToString( );
textBox1.Text = model.AM223.ToString( );
textBox7.Text = model.AM224.ToString( );
textBox23.Text = model.AM225.ToString( );
textBox22.Text = model.AM226.ToString( );
textBox21.Text = model.AM227.ToString( );
textBox20.Text = model.AM228.ToString( );
textBox19.Text = model.AM229.ToString( );
textBox18.Text = model.AM230.ToString( );
textBox17.Text = model.AM231.ToString( );
textBox16.Text = model.AM232.ToString( );
textBox15.Text = model.AM233.ToString( );
textBox14.Text = model.AM234.ToString( );
textBox13.Text = model.AM235.ToString( );
textBox12.Text = model.AM236.ToString( );
textBox11.Text = model.AM237.ToString( );
textBox10.Text = model.AM238.ToString( );
textBox9.Text = model.AM255.ToString( );
textBox8.Text = model.AM256.ToString( );
}
private void ProductPlywoodAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox325.Text = model.AM298.ToString( );
textBox324.Text = model.AM299.ToString( );
textBox323.Text = model.AM300.ToString( );
textBox1.Text = model.AM303.ToString( );
textBox331.Text = model.AM301.ToString( );
textBox330.Text = model.AM302.ToString( );
textBox329.Text = model.AM306.ToString( );
textBox2.Text = model.AM309.ToString( );
textBox334.Text = model.AM304.ToString( );
textBox333.Text = model.AM305.ToString( );
textBox332.Text = model.AM313.ToString( );
textBox3.Text = model.AM317.ToString( );
textBox337.Text = model.AM307.ToString( );
textBox336.Text = model.AM308.ToString( );
textBox335.Text = model.AM320.ToString( );
textBox5.Text = model.AM323.ToString( );
textBox340.Text = model.AM311.ToString( );
textBox339.Text = model.AM312.ToString( );
textBox338.Text = model.AM324.ToString( );
textBox6.Text = model.AM325.ToString( );
textBox43.Text = model.AM315.ToString( );
textBox42.Text = model.AM316.ToString( );
textBox41.Text = model.AM326.ToString( );
textBox7.Text = model.AM327.ToString( );
textBox37.Text = model.AM318.ToString( );
textBox36.Text = model.AM319.ToString( );
textBox35.Text = model.AM328.ToString( );
textBox4.Text = model.AM329.ToString( );
textBox40.Text = model.AM321.ToString( );
textBox39.Text = model.AM322.ToString( );
textBox38.Text = model.AM296.ToString( );
textBox8.Text = model.AM297.ToString( );
}
private void ProductGunPaintAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox262.Text = model.AM239.ToString( );
textBox261.Text = model.AM240.ToString( );
textBox260.Text = model.AM241.ToString( );
textBox1.Text = model.AM244.ToString( );
textBox268.Text = model.AM242.ToString( );
textBox267.Text = model.AM243.ToString( );
textBox266.Text = model.AM247.ToString( );
textBox4.Text = model.AM251.ToString( );
textBox271.Text = model.AM245.ToString( );
textBox270.Text = model.AM246.ToString( );
textBox269.Text = model.AM252.ToString( );
textBox5.Text = model.AM253.ToString( );
textBox3.Text = model.AM249.ToString( );
textBox2.Text = model.AM250.ToString( );
}
/// <summary>
/// 写入数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool UpdateOfReceivable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
return(dao.UpdateOfReceivable(modelAm, oddNum));
}
void ByOneBy(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum, ArrayList SQLString)
{
//modelAm.AM212 = modelAm.AM217 = modelAm.AM215 = modelAm.AM221 = modelAm.AM218 = modelAm.AM223 = 0;
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT AMB212,AMB215,AMB217,AMB218,AMB221,AMB223,AMB229,AMB231,AMB233,AMB235,AMB237,AMB255 FROM R_PQAMB WHERE AMB001='{0}'", oddNum);
DataTable de = SqlHelper.ExecuteDataTable("SELECT AM212,AM215,AM217,AM218,AM221,AM223,AM229,AM231,AM233,AM235,AM237,AM255 FROM R_PQAM WHERE AM002='" + modelAm.AM002 + "'");
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (da != null && da.Rows.Count > 0)
{
if (modelAm.AM212 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB212='{0}' WHERE AMB001='{1}'", modelAm.AM212, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM215 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB215='{0}' WHERE AMB001='{1}'", modelAm.AM215, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM217 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB217='{0}' WHERE AMB001='{1}'", modelAm.AM217, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM218 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB218='{0}' WHERE AMB001='{1}'", modelAm.AM218, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM221 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB221='{0}' WHERE AMB001='{1}'", modelAm.AM221, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM223 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB223='{0}' WHERE AMB001='{1}'", modelAm.AM223, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM229 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB229='{0}' WHERE AMB001='{1}'", modelAm.AM229, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM231 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB231='{0}' WHERE AMB001='{1}'", modelAm.AM231, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM233 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB233='{0}' WHERE AMB001='{1}'", modelAm.AM233, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM235 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB235='{0}' WHERE AMB001='{1}'", modelAm.AM235, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM237 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB237='{0}' WHERE AMB001='{1}'", modelAm.AM237, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM255 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB255='{0}' WHERE AMB001='{1}'", modelAm.AM255, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (de != null && de.Rows.Count > 0)
{
modelAm.AM212 = modelAm.AM212 - (string.IsNullOrEmpty(da.Rows[0]["AMB212"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB212"].ToString( )));
modelAm.AM215 = modelAm.AM215 - (string.IsNullOrEmpty(da.Rows[0]["AMB215"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB215"].ToString( )));
modelAm.AM217 = modelAm.AM217 - (string.IsNullOrEmpty(da.Rows[0]["AMB217"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB217"].ToString( )));
modelAm.AM218 = modelAm.AM218 - (string.IsNullOrEmpty(da.Rows[0]["AMB218"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB218"].ToString( )));
modelAm.AM221 = modelAm.AM221 - (string.IsNullOrEmpty(da.Rows[0]["AMB221"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB221"].ToString( )));
modelAm.AM223 = modelAm.AM223 - (string.IsNullOrEmpty(da.Rows[0]["AMB223"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB223"].ToString( )));
modelAm.AM229 = modelAm.AM229 - (string.IsNullOrEmpty(da.Rows [0] ["AMB229"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB229"].ToString( )));
modelAm.AM231 = modelAm.AM231 - (string.IsNullOrEmpty(da.Rows [0] ["AMB231"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB231"].ToString( )));
modelAm.AM233 = modelAm.AM233 - (string.IsNullOrEmpty(da.Rows [0] ["AMB233"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB233"].ToString( )));
modelAm.AM235 = modelAm.AM235 - (string.IsNullOrEmpty(da.Rows [0] ["AMB235"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB235"].ToString( )));
modelAm.AM237 = modelAm.AM237 - (string.IsNullOrEmpty(da.Rows [0] ["AMB237"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB237"].ToString( )));
modelAm.AM255 = modelAm.AM255 - (string.IsNullOrEmpty(da.Rows [0] ["AMB255"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB255"].ToString( )));
modelAm.AM212 = modelAm.AM212 + (string.IsNullOrEmpty(de.Rows[0]["AM212"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM212"].ToString( )));
modelAm.AM215 = modelAm.AM215 + (string.IsNullOrEmpty(de.Rows[0]["AM215"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM215"].ToString( )));
modelAm.AM217 = modelAm.AM217 + (string.IsNullOrEmpty(de.Rows[0]["AM217"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM217"].ToString( )));
modelAm.AM218 = modelAm.AM218 + (string.IsNullOrEmpty(de.Rows[0]["AM218"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM218"].ToString( )));
modelAm.AM221 = modelAm.AM221 + (string.IsNullOrEmpty(de.Rows[0]["AM221"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM221"].ToString( )));
modelAm.AM223 = modelAm.AM223 + (string.IsNullOrEmpty(de.Rows[0]["AM223"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM223"].ToString( )));
modelAm.AM229 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM229"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM229"].ToString( )));
modelAm.AM231 = modelAm.AM231 + (string.IsNullOrEmpty(de.Rows [0] ["AM231"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM231"].ToString( )));
modelAm.AM233 = modelAm.AM233 + (string.IsNullOrEmpty(de.Rows [0] ["AM233"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM233"].ToString( )));
modelAm.AM235 = modelAm.AM231 + (string.IsNullOrEmpty(de.Rows [0] ["AM235"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM235"].ToString( )));
modelAm.AM237 = modelAm.AM231 + (string.IsNullOrEmpty(de.Rows [0] ["AM237"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM237"].ToString( )));
modelAm.AM255 = modelAm.AM231 + (string.IsNullOrEmpty(de.Rows [0] ["AM255"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM255"].ToString( )));
}
}
else
{
strSql = new StringBuilder( );
strSql.AppendFormat("INSERT INTO R_PQAMB (AMB001,AMB212,AMB215,AMB217,AMB218,AMB221,AMB223,AMB229,AMB231,AMB233,AMB235,AMB237,AMB255) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')", oddNum, modelAm.AM212, modelAm.AM215, modelAm.AM217, modelAm.AM218, modelAm.AM221, modelAm.AM223, modelAm.AM229, modelAm.AM231, modelAm.AM233, modelAm.AM235, modelAm.AM237, modelAm.AM255);
SQLString.Add(strSql.ToString( ));
if (de != null && de.Rows.Count > 0)
{
modelAm.AM212 = modelAm.AM212 + (string.IsNullOrEmpty(de.Rows[0]["AM212"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM212"].ToString( )));
modelAm.AM215 = modelAm.AM215 + (string.IsNullOrEmpty(de.Rows[0]["AM215"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM215"].ToString( )));
modelAm.AM217 = modelAm.AM217 + (string.IsNullOrEmpty(de.Rows[0]["AM217"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM217"].ToString( )));
modelAm.AM218 = modelAm.AM218 + (string.IsNullOrEmpty(de.Rows[0]["AM218"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM218"].ToString( )));
modelAm.AM221 = modelAm.AM221 + (string.IsNullOrEmpty(de.Rows[0]["AM221"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM221"].ToString( )));
modelAm.AM223 = modelAm.AM223 + (string.IsNullOrEmpty(de.Rows[0]["AM223"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM223"].ToString( )));
modelAm.AM229 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM229"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM229"].ToString( )));
modelAm.AM231 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM231"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM231"].ToString( )));
modelAm.AM233 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM233"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM233"].ToString( )));
modelAm.AM235 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM235"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM235"].ToString( )));
modelAm.AM237 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM237"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM237"].ToString( )));
modelAm.AM255 = modelAm.AM229 + (string.IsNullOrEmpty(de.Rows [0] ["AM255"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM255"].ToString( )));
}
}
}
/// <summary>
/// 写数据到241
/// </summary>
/// <param name="modelAm"></param>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool UpdateOfReveciable(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum)
{
ArrayList SQLString = new ArrayList( );
ByOneBy(modelAm, oddNum, SQLString);
//WriteReceivableToGeneralLedger.ByOneBySu( modelAm ,oddNum ,SQLString );
StringBuilder strSql = new StringBuilder( );
if (modelAm.AM212 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM212='{0}' WHERE AM002='{1}'", modelAm.AM212, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM215 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM215='{0}' WHERE AM002='{1}'", modelAm.AM215, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM217 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM217='{0}' WHERE AM002='{1}'", modelAm.AM217, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM218 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM218='{0}' WHERE AM002='{1}'", modelAm.AM218, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM221 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM221='{0}' WHERE AM002='{1}'", modelAm.AM221, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM223 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM223='{0}' WHERE AM002='{1}'", modelAm.AM223, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM229 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM229='{0}' WHERE AM002='{1}'", modelAm.AM229, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM231 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM231='{0}' WHERE AM002='{1}'", modelAm.AM231, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM233 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM233='{0}' WHERE AM002='{1}'", modelAm.AM233, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM235 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM235='{0}' WHERE AM002='{1}'", modelAm.AM235, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM237 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM237='{0}' WHERE AM002='{1}'", modelAm.AM237, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM255 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAM SET AM255='{0}' WHERE AM002='{1}'", modelAm.AM255, modelAm.AM002);
SQLString.Add(strSql.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void ByOneBy(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum, ArrayList SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT AMB209,AMB211,AMB225,AMB227 FROM R_PQAMB WHERE AMB001='{0}'", oddNum);
DataTable de = SqlHelper.ExecuteDataTable("SELECT AM209,AM211,AM225,AM227 FROM R_PQAM WHERE AM002='" + modelAm.AM002 + "'");
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (da != null && da.Rows.Count > 0)
{
if (modelAm.AM209 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB209='{0}' WHERE AMB001='{1}'", modelAm.AM209, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM211 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB211='{0}' WHERE AMB001='{1}'", modelAm.AM211, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM225 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB225='{0}' WHERE AMB001='{1}'", modelAm.AM225, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM227 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB227='{0}' WHERE AMB001='{1}'", modelAm.AM227, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (de != null && de.Rows.Count > 0)
{
modelAm.AM209 = modelAm.AM209 - (string.IsNullOrEmpty(da.Rows[0]["AMB209"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB209"].ToString( )));
modelAm.AM211 = modelAm.AM211 - (string.IsNullOrEmpty(da.Rows[0]["AMB211"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB211"].ToString( )));
modelAm.AM225 = modelAm.AM225 - (string.IsNullOrEmpty(da.Rows [0] ["AMB225"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB225"].ToString( )));
modelAm.AM227 = modelAm.AM225 - (string.IsNullOrEmpty(da.Rows [0] ["AMB227"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows [0] ["AMB227"].ToString( )));
modelAm.AM209 = modelAm.AM209 + (string.IsNullOrEmpty(de.Rows[0]["AM209"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM209"].ToString( )));
modelAm.AM211 = modelAm.AM211 + (string.IsNullOrEmpty(de.Rows[0]["AM211"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM211"].ToString( )));
modelAm.AM225 = modelAm.AM211 + (string.IsNullOrEmpty(de.Rows [0] ["AM225"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM225"].ToString( )));
modelAm.AM227 = modelAm.AM211 + (string.IsNullOrEmpty(de.Rows [0] ["AM227"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM227"].ToString( )));
}
}
else
{
strSql = new StringBuilder( );
strSql.AppendFormat("INSERT INTO R_PQAMB (AMB001,AMB209,AMB211,AMB225,AMB227) VALUES ('{0}','{1}','{2}','{3}','{4}')", oddNum, modelAm.AM209, modelAm.AM211, modelAm.AM225, modelAm.AM227);
SQLString.Add(strSql.ToString( ));
if (de != null && de.Rows.Count > 0)
{
modelAm.AM209 = modelAm.AM209 + (string.IsNullOrEmpty(de.Rows[0]["AM209"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM209"].ToString( )));
modelAm.AM211 = modelAm.AM211 + (string.IsNullOrEmpty(de.Rows[0]["AM211"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM211"].ToString( )));
modelAm.AM225 = modelAm.AM225 + (string.IsNullOrEmpty(de.Rows [0] ["AM225"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM225"].ToString( )));
modelAm.AM227 = modelAm.AM227 + (string.IsNullOrEmpty(de.Rows [0] ["AM227"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows [0] ["AM227"].ToString( )));
}
}
}
public bool ProductBeforeAndAfterRoadWages(MulaolaoLibrary.ProductCostSummaryLibrary model)
{
return(dao.ProductBeforeAndAfterRoadWages(model));
}
private void ProductWoodAll_Load(object sender, EventArgs e)
{
this.MouseDown += new System.Windows.Forms.MouseEventHandler(Form_MouseDown);
this.MouseMove += new System.Windows.Forms.MouseEventHandler(Form_MouseMove);
this.MouseUp += new System.Windows.Forms.MouseEventHandler(Form_MouseUp);
model = bll.GetModel(id);
textBox364.Text = model.AM336.ToString( );
textBox363.Text = model.AM337.ToString( );
textBox362.Text = model.AM338.ToString( );
textBox25.Text = model.AM341.ToString( );
textBox370.Text = model.AM339.ToString( );
textBox369.Text = model.AM340.ToString( );
textBox368.Text = model.AM345.ToString( );
textBox39.Text = model.AM348.ToString( );
textBox373.Text = model.AM343.ToString( );
textBox372.Text = model.AM344.ToString( );
textBox371.Text = model.AM351.ToString( );
textBox26.Text = model.AM354.ToString( );
textBox376.Text = model.AM346.ToString( );
textBox375.Text = model.AM347.ToString( );
textBox374.Text = model.AM357.ToString( );
textBox28.Text = model.AM360.ToString( );
textBox379.Text = model.AM349.ToString( );
textBox378.Text = model.AM350.ToString( );
textBox377.Text = model.AM363.ToString( );
textBox29.Text = model.AM366.ToString( );
textBox382.Text = model.AM352.ToString( );
textBox381.Text = model.AM353.ToString( );
textBox380.Text = model.AM369.ToString( );
textBox31.Text = model.AM372.ToString( );
textBox385.Text = model.AM355.ToString( );
textBox384.Text = model.AM356.ToString( );
textBox383.Text = model.AM332.ToString( );
textBox41.Text = model.AM335.ToString( );
textBox388.Text = model.AM358.ToString( );
textBox387.Text = model.AM359.ToString( );
textBox386.Text = model.AM375.ToString( );
textBox32.Text = model.AM378.ToString( );
textBox391.Text = model.AM361.ToString( );
textBox390.Text = model.AM362.ToString( );
textBox389.Text = model.AM381.ToString( );
textBox27.Text = model.AM387.ToString( );
textBox394.Text = model.AM364.ToString( );
textBox393.Text = model.AM365.ToString( );
textBox392.Text = model.AM390.ToString( );
textBox40.Text = model.AM393.ToString( );
textBox397.Text = model.AM367.ToString( );
textBox396.Text = model.AM368.ToString( );
textBox395.Text = model.AM294.ToString( );
textBox30.Text = model.AM295.ToString( );
textBox400.Text = model.AM370.ToString( );
textBox399.Text = model.AM371.ToString( );
textBox398.Text = model.AM292.ToString( );
textBox43.Text = model.AM293.ToString( );
textBox24.Text = model.AM330.ToString( );
textBox23.Text = model.AM331.ToString( );
textBox22.Text = model.AM290.ToString( );
textBox42.Text = model.AM291.ToString( );
textBox21.Text = model.AM333.ToString( );
textBox20.Text = model.AM334.ToString( );
textBox19.Text = model.AM288.ToString( );
textBox44.Text = model.AM289.ToString( );
textBox3.Text = model.AM373.ToString( );
textBox2.Text = model.AM374.ToString( );
textBox1.Text = model.AM287.ToString( );
textBox33.Text = model.AM269.ToString( );
textBox6.Text = model.AM376.ToString( );
textBox5.Text = model.AM377.ToString( );
textBox4.Text = model.AM267.ToString( );
textBox34.Text = model.AM268.ToString( );
textBox9.Text = model.AM379.ToString( );
textBox8.Text = model.AM380.ToString( );
textBox7.Text = model.AM265.ToString( );
textBox35.Text = model.AM266.ToString( );
textBox12.Text = model.AM385.ToString( );
textBox11.Text = model.AM386.ToString( );
textBox10.Text = model.AM382.ToString( );
textBox36.Text = model.AM383.ToString( );
textBox15.Text = model.AM388.ToString( );
textBox14.Text = model.AM389.ToString( );
textBox13.Text = model.AM263.ToString( );
textBox37.Text = model.AM264.ToString( );
textBox18.Text = model.AM391.ToString( );
textBox17.Text = model.AM392.ToString( );
textBox16.Text = model.AM261.ToString( );
textBox38.Text = model.AM262.ToString( );
}
public bool ContractProcess(MulaolaoLibrary.ProductCostSummaryLibrary model)
{
return(dao.ContractProcess(model));
}
void ByOneBy(MulaolaoLibrary.ProductCostSummaryLibrary modelAm, string oddNum, ArrayList SQLString)
{
// modelAm.AM108 = modelAm.AM110 = modelAm.AM111 = modelAm.AM115 = 0M;
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT AMB108,AMB110,AMB111,AMB115 FROM R_PQAMB WHERE AMB001='{0}'", oddNum);
DataTable de = SqlHelper.ExecuteDataTable("SELECT AM108,AM110,AM111,AM115 FROM R_PQAM WHERE AM002='" + modelAm.AM002 + "'");
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (da != null && da.Rows.Count > 0)
{
if (modelAm.AM108 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB108='{0}' AND AMB001='{1}'", modelAm.AM108, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM110 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB110='{0}' AND AMB001='{1}'", modelAm.AM110, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM111 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB111='{0}' AND AMB001='{1}'", modelAm.AM111, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (modelAm.AM115 > 0)
{
strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE R_PQAMB SET AMB115='{0}' AND AMB001='{1}'", modelAm.AM115, oddNum);
SQLString.Add(strSql.ToString( ));
}
if (de != null && de.Rows.Count > 0)
{
modelAm.AM108 = modelAm.AM108 - (string.IsNullOrEmpty(da.Rows[0]["AMB108"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB108"].ToString( )));
modelAm.AM110 = modelAm.AM110 - (string.IsNullOrEmpty(da.Rows[0]["AMB110"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB110"].ToString( )));
modelAm.AM111 = modelAm.AM111 - (string.IsNullOrEmpty(da.Rows[0]["AMB111"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB111"].ToString( )));
modelAm.AM115 = modelAm.AM115 - (string.IsNullOrEmpty(da.Rows[0]["AMB115"].ToString( )) == true ? 0 : Convert.ToDecimal(da.Rows[0]["AMB115"].ToString( )));
modelAm.AM108 = modelAm.AM108 + (string.IsNullOrEmpty(de.Rows[0]["AM108"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM108"].ToString( )));
modelAm.AM110 = modelAm.AM110 + (string.IsNullOrEmpty(de.Rows[0]["AM110"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM110"].ToString( )));
modelAm.AM111 = modelAm.AM111 + (string.IsNullOrEmpty(de.Rows[0]["AM111"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM111"].ToString( )));
modelAm.AM115 = modelAm.AM115 + (string.IsNullOrEmpty(de.Rows[0]["AM115"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM115"].ToString( )));
}
}
else
{
strSql = new StringBuilder( );
strSql.AppendFormat("INSERT INTO R_PQAMB (AMB001,AMB108,AMB110,AMB111,AMB115) VALUES ('{0}','{1}','{2}','{3}','{4}')", oddNum, modelAm.AM108, modelAm.AM110, modelAm.AM111, modelAm.AM115);
SQLString.Add(strSql.ToString( ));
if (de != null && de.Rows.Count > 0)
{
modelAm.AM108 = modelAm.AM108 + (string.IsNullOrEmpty(de.Rows[0]["AM108"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM108"].ToString( )));
modelAm.AM110 = modelAm.AM110 + (string.IsNullOrEmpty(de.Rows[0]["AM110"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM110"].ToString( )));
modelAm.AM111 = modelAm.AM111 + (string.IsNullOrEmpty(de.Rows[0]["AM111"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM111"].ToString( )));
modelAm.AM115 = modelAm.AM115 + (string.IsNullOrEmpty(de.Rows[0]["AM115"].ToString( )) == true ? 0 : Convert.ToDecimal(de.Rows[0]["AM115"].ToString( )));
}
}
}
public bool FinishedProductOutsourcing(MulaolaoLibrary.ProductCostSummaryLibrary model)
{
return(dao.FinishedProductOutsourcing(model));
}
