/// <summary>
/// 编辑上次入库记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateStr(MulaolaoLibrary.WuJinContractLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQU SET ");
strSql.Append("PQU109=@PQU109,");
strSql.Append("PQU110=@PQU110");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@PQU109", SqlDbType.BigInt),
new SqlParameter("@PQU110", SqlDbType.BigInt),
new SqlParameter("@PQU109", SqlDbType.BigInt),
};
parameter[0].Value = model.PQU109;
parameter[0].Value = model.PQU110;
parameter[0].Value = model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public r343(MulaolaoLibrary.WuJinContractLibrary model)
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.QuoBll( );
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { View });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { View });
this.model = model;
setValue( );
getInfo( );
}
/// <summary>
/// 批量编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBatch(MulaolaoLibrary.WuJinContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNum, string stateOf, string stateOfOdd)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQU SET ");
strSql.AppendFormat("PQU101='{0}',", model.PQU101);
strSql.AppendFormat("PQU104='{0}',", model.PQU104);
strSql.AppendFormat("PQU18='{0}'", model.PQU18);
strSql.AppendFormat(" WHERE idx='{0}'", model.IDX);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, oddNum, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void read343( )
{
r343model.PQU04 = dt;
r343 form = new r343(r343model);
if (form.ShowDialog( ) == DialogResult.OK)
{
r343model = form.getModel;
if (r343model == null)
{
return;
}
_qup.QUR004 = r343model.PQU10;
_qup.QUR015 = r343model.PQU12;
_qup.QUR006 = r343model.PQU13;
_qup.QUR013 = r343model.PQU16;
_qup.QUR010 = r343model.PQU18;
_qup.QUR016 = 0;
editRow( );
}
}
/// <summary>
/// 批量编辑
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBatch(MulaolaoLibrary.WuJinContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string oddNumn, string stateOf, string stateOfOdd)
{
return(dao.UpdateBatch(model, tableNum, tableName, logins, dtOne, oddNumn, stateOf, stateOfOdd));
}
/// <summary>
/// 编辑上次入库记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateStr(MulaolaoLibrary.WuJinContractLibrary model)
{
return(dao.UpdateStr(model));
}
void choiseCon( )
{
if (DicStr.r195.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r195Model = new MulaolaoLibrary.ChanPinZhiBiaoLibrary( );
}
read195( );
}
else if (DicStr.r196.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r196model = new MulaolaoLibrary.SiReYiYinContractLibrary( );
}
read196( );
}
else if (DicStr.r338.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r338model = new MulaolaoLibrary.JiaoMiDuContractLibrary( );
}
read338( );
}
else if (DicStr.r341.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r341model = new MulaolaoLibrary.MuCaiContractLibrary( );
}
read341( );
}
else if (DicStr.r342.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r342model = new MulaolaoLibrary.CheMuJianContractLibrary( );
}
read342( );
}
else if (DicStr.r343.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r343model = new MulaolaoLibrary.WuJinContractLibrary( );
}
read343( );
}
else if (DicStr.r347.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r347model = new MulaolaoLibrary.SuLiaoBuQiContractLibrary( );
}
read347( );
}
else if (DicStr.r349.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r349model = new MulaolaoLibrary.WaiXianContractLibrary( );
}
read349( );
}
else if (DicStr.r339.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r339model = new MulaolaoLibrary.YouQiLibrary( );
}
read339( );
}
else if (DicStr.r344.Equals(_qup.QUR003))
{
if ("add".Equals(conState))
{
r344model = new MulaolaoLibrary.GunQiContractLibrary( );
}
read344( );
}
gridControl1.RefreshDataSource( );
}
void setValueToModel( )
{
if (DicStr.r195.Equals(_qup.QUR003))
{
r195Model = new MulaolaoLibrary.ChanPinZhiBiaoLibrary( );
r195Model.CP06 = _qup.QUR004;
r195Model.CP07 = _qup.QUR015;
r195Model.CP09 = _qup.QUR005;
r195Model.CP10 = Convert.ToDecimal(_qup.QUR013);
r195Model.CP13 = Convert.ToDecimal(_qup.QUR006);
}
else if (DicStr.r196.Equals(_qup.QUR003))
{
r196model = new MulaolaoLibrary.SiReYiYinContractLibrary( );
r196model.AH10 = _qup.QUR004;
r196model.AH18 = _qup.QUR005;
r196model.AH13 = Convert.ToDecimal(_qup.QUR006);
r196model.AH16 = Convert.ToDecimal(_qup.QUR013);
r196model.AH11 = _qup.QUR015;
}
else if (DicStr.r338.Equals(_qup.QUR003))
{
r338model = new MulaolaoLibrary.JiaoMiDuContractLibrary( );
r338model.JM09 = _qup.QUR004;
r338model.JM10 = Convert.ToDecimal(_qup.QUR006);
r338model.JM94 = Convert.ToDecimal(_qup.QUR007);
r338model.JM95 = Convert.ToDecimal(_qup.QUR008);
r338model.JM96 = Convert.ToDecimal(_qup.QUR009);
r338model.JM15 = Convert.ToDecimal(_qup.QUR010);
r338model.JM120 = _qup.QUR012;
r338model.JM11 = Convert.ToDecimal(_qup.QUR013);
}
else if (DicStr.r341.Equals(_qup.QUR003))
{
r341model = new MulaolaoLibrary.MuCaiContractLibrary( );
r341model.PQV10 = _qup.QUR004;
r341model.PQV12 = Convert.ToInt32(_qup.QUR006);
r341model.PQV71 = Convert.ToDecimal(_qup.QUR007);
r341model.PQV72 = Convert.ToDecimal(_qup.QUR008);
r341model.PQV73 = Convert.ToDecimal(_qup.QUR009);
r341model.PQV64 = Convert.ToDecimal(_qup.QUR010);
r341model.PQV11 = Convert.ToDecimal(_qup.QUR012);
}
else if (DicStr.r342.Equals(_qup.QUR003))
{
r342model = new MulaolaoLibrary.CheMuJianContractLibrary( );
r342model.AF015 = _qup.QUR004;
r342model.AF019 = Convert.ToInt32(_qup.QUR006);
r342model.AF020 = Convert.ToDecimal(_qup.QUR007);
r342model.AF021 = Convert.ToDecimal(_qup.QUR008);
r342model.AF022 = Convert.ToDecimal(_qup.QUR009);
r342model.AF018 = Convert.ToInt64(_qup.QUR010);
r342model.AF023 = Convert.ToDecimal(_qup.QUR013);
r342model.AF087 = Convert.ToDecimal(_qup.QUR012);
r342model.AF088 = Convert.ToDecimal(_qup.QUR014);
}
else if (DicStr.r343.Equals(_qup.QUR003))
{
r343model = new MulaolaoLibrary.WuJinContractLibrary( );
r343model.PQU10 = _qup.QUR004;
r343model.PQU12 = _qup.QUR015;
r343model.PQU13 = _qup.QUR006;
r343model.PQU16 = _qup.QUR013;
r343model.PQU18 = _qup.QUR010;
}
else if (DicStr.r347.Equals(_qup.QUR003))
{
r347model = new MulaolaoLibrary.SuLiaoBuQiContractLibrary( );
r347model.PJ09 = _qup.QUR004;
r347model.PJ89 = _qup.QUR015;
r347model.PJ11 = _qup.QUR006;
r347model.PJ12 = _qup.QUR013;
r347model.PJ97 = _qup.QUR010;
}
else if (DicStr.r349.Equals(_qup.QUR003))
{
r349model = new MulaolaoLibrary.WaiXianContractLibrary( );
r349model.WX10 = _qup.QUR004;
r349model.WX11 = _qup.QUR015;
r349model.WX13 = _qup.QUR013;
r349model.WX14 = _qup.QUR006;
r349model.WX16 = Convert.ToInt64(_qup.QUR010);
}
else if (DicStr.r339.Equals(_qup.QUR003))
{
r339model = new MulaolaoLibrary.YouQiLibrary( );
r339model.YQ10 = _qup.QUR004;
r339model.YQ112 = Convert.ToInt32(_qup.QUR006);
r339model.YQ119 = _qup.QUR005;
r339model.YQ19 = Convert.ToDecimal(_qup.QUR010);
}
else if (DicStr.r344.Equals(_qup.QUR003))
{
r344model = new MulaolaoLibrary.GunQiContractLibrary( );
r344model.MZ016 = _qup.QUR004;
r344model.MZ018 = _qup.QUR015;
r344model.MZ021 = Convert.ToInt32(_qup.QUR010);
r344model.MZ025 = Convert.ToDecimal(_qup.QUR013);
r344model.MZ105 = Convert.ToDecimal(_qup.QUR016);
}
}
