/// <summary>
/// 编辑上次更新记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateStr(MulaolaoLibrary.CheMuJianContractLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAF SET ");
strSql.Append("AF080=@AF080,");
strSql.Append("AF081=@AF081");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@AF080", SqlDbType.BigInt),
new SqlParameter("@AF081", SqlDbType.BigInt),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = model.AF080;
parameter[1].Value = model.AF081;
parameter[2].Value = model.idx;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
void read342( )
{
r342model.AF009 = dt;
r342 form = new r342(r342model);
if (form.ShowDialog( ) == DialogResult.OK)
{
r342model = form.getModel;
if (r342model == null)
{
return;
}
_qup.QUR004 = r342model.AF015;
_qup.QUR006 = r342model.AF019;
_qup.QUR007 = r342model.AF020.ToString( );
_qup.QUR008 = r342model.AF021.ToString( );
_qup.QUR009 = r342model.AF022.ToString( );
_qup.QUR010 = r342model.AF018;
_qup.QUR012 = r342model.AF087;
_qup.QUR013 = r342model.AF023;
_qup.QUR014 = r342model.AF088;
_qup.QUR015 = r342model.AF020 + "*" + r342model.AF021 + "*" + r342model.AF022;
_qup.QUR016 = Convert.ToDecimal(r342model.AF020) * Convert.ToDecimal(r342model.AF021) * Convert.ToDecimal(r342model.AF022);
editRow( );
}
}
public r342(MulaolaoLibrary.CheMuJianContractLibrary 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.CheMuJianContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAF SET ");
strSql.AppendFormat("AF006='{0}',", model.AF006);
strSql.AppendFormat("AF017='{0}',", model.AF017);
strSql.AppendFormat("AF018='{0}'", model.AF018);
strSql.AppendFormat(" WHERE idx='{0}'", model.idx);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.AF001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="model"></param>
/// <param name="tableNum"></param>
/// <param name="tableName"></param>
/// <param name="logins"></param>
/// <param name="dtOne"></param>
/// <param name="stateOf"></param>
/// <param name="stateOfOdd"></param>
/// <returns></returns>
public bool DeleteAll(MulaolaoLibrary.CheMuJianContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_PQAF WHERE AF001='{0}'", model.AF001);
SQLString.Add(strSql.ToString( ));
StringBuilder strSq = new StringBuilder( );
strSq.AppendFormat("DELETE FROM R_REVIEWS WHERE RES01='{0}' AND RES06='{1}'", tableNum, model.AF001);
SQLString.Add(strSq.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.AF001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
if (stateOfOdd == "维护删除")
{
strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_PQAMB WHERE AMB001='{0}'", model.AF001);
SQLString.Add(strSql.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 更改记录
/// </summary>
/// <param name="model"></param>
/// <param name="tableNum"></param>
/// <param name="tableName"></param>
/// <param name="logins"></param>
/// <param name="dtOne"></param>
/// <param name="stateOf"></param>
/// <param name="stateOfOdd"></param>
/// <returns></returns>
public bool UpdateOfAll(MulaolaoLibrary.CheMuJianContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
return(dao.UpdateOfAll(model, tableNum, tableName, logins, dtOne, stateOf, stateOfOdd));
}
/// <summary>
/// 编辑上次更新记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateStr(MulaolaoLibrary.CheMuJianContractLibrary model)
{
return(dao.UpdateStr(model));
}
/// <summary>
/// 更改记录
/// </summary>
/// <param name="model"></param>
/// <param name="tableNum"></param>
/// <param name="tableName"></param>
/// <param name="logins"></param>
/// <param name="dtOne"></param>
/// <param name="stateOf"></param>
/// <param name="stateOfOdd"></param>
/// <returns></returns>
public bool UpdateOfAll(MulaolaoLibrary.CheMuJianContractLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAF SET ");
strSql.AppendFormat("AF002='{0}',", model.AF002);
strSql.AppendFormat("AF003='{0}',", model.AF003);
strSql.AppendFormat("AF004='{0}',", model.AF004);
strSql.AppendFormat("AF005='{0}',", model.AF005);
strSql.AppendFormat("AF007='{0}',", model.AF007);
strSql.AppendFormat("AF008='{0}',", model.AF008);
strSql.AppendFormat("AF009='{0}',", model.AF009);
strSql.AppendFormat("AF010='{0}',", model.AF010);
strSql.AppendFormat("AF011='{0}',", model.AF011);
strSql.AppendFormat("AF012='{0}',", model.AF012);
strSql.AppendFormat("AF013='{0}',", model.AF013);
strSql.AppendFormat("AF014='{0}',", model.AF014);
strSql.AppendFormat("AF035='{0}',", model.AF035);
strSql.AppendFormat("AF036='{0}',", model.AF036);
strSql.AppendFormat("AF037='{0}',", model.AF037);
strSql.AppendFormat("AF038='{0}',", model.AF038);
strSql.AppendFormat("AF039='{0}',", model.AF039);
strSql.AppendFormat("AF040='{0}',", model.AF040);
strSql.AppendFormat("AF041='{0}',", model.AF041);
strSql.AppendFormat("AF042='{0}',", model.AF042);
strSql.AppendFormat("AF043='{0}',", model.AF043);
strSql.AppendFormat("AF044='{0}',", model.AF044);
strSql.AppendFormat("AF045='{0}',", model.AF045);
strSql.AppendFormat("AF046='{0}',", model.AF046);
strSql.AppendFormat("AF047='{0}',", model.AF047);
strSql.AppendFormat("AF048='{0}',", model.AF048);
strSql.AppendFormat("AF049='{0}',", model.AF049);
strSql.AppendFormat("AF050='{0}',", model.AF050);
strSql.AppendFormat("AF051='{0}',", model.AF051);
strSql.AppendFormat("AF052='{0}',", model.AF052);
strSql.AppendFormat("AF053='{0}',", model.AF053);
strSql.AppendFormat("AF054='{0}',", model.AF054);
strSql.AppendFormat("AF055='{0}',", model.AF055);
strSql.AppendFormat("AF056='{0}',", model.AF056);
strSql.AppendFormat("AF057='{0}',", model.AF057);
strSql.AppendFormat("AF058='{0}',", model.AF058);
strSql.AppendFormat("AF059='{0}',", model.AF059);
strSql.AppendFormat("AF060='{0}',", model.AF060);
strSql.AppendFormat("AF061='{0}',", model.AF061);
strSql.AppendFormat("AF062='{0}',", model.AF062);
strSql.AppendFormat("AF063='{0}',", model.AF063);
strSql.AppendFormat("AF064='{0}',", model.AF064);
strSql.AppendFormat("AF065='{0}',", model.AF065);
strSql.AppendFormat("AF066='{0}',", model.AF066);
strSql.AppendFormat("AF067='{0}',", model.AF067);
strSql.AppendFormat("AF068='{0}',", model.AF068);
strSql.AppendFormat("AF069='{0}',", model.AF069);
strSql.AppendFormat("AF070='{0}',", model.AF070);
strSql.AppendFormat("AF071='{0}',", model.AF071);
strSql.AppendFormat("AF072='{0}',", model.AF072);
strSql.AppendFormat("AF073='{0}',", model.AF073);
strSql.AppendFormat("AF074='{0}',", model.AF074);
strSql.AppendFormat("AF075='{0}',", model.AF075);
strSql.AppendFormat("AF077='{0}',", model.AF077);
strSql.AppendFormat("AF078='{0}',", model.AF078);
strSql.AppendFormat("AF079='{0}',", model.AF079);
strSql.AppendFormat("AF083='{0}'", model.AF083);
strSql.AppendFormat(" WHERE AF001='{0}'", model.AF001);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.AF001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
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);
}
}