/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool UpdateOfOne(MulaolaoLibrary.ContractToDoAJobLibrary _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_PQBA SET ");
strSql.AppendFormat("BA001='{0}',", _model.BA001);
strSql.AppendFormat("BA006='{0}',", _model.BA006);
strSql.AppendFormat("BA007='{0}',", _model.BA007);
strSql.AppendFormat("BA008='{0}',", _model.BA008);
strSql.AppendFormat("BA009='{0}',", _model.BA009);
strSql.AppendFormat("BA010='{0}',", _model.BA010);
strSql.AppendFormat("BA011='{0}',", _model.BA011);
strSql.AppendFormat("BA012='{0}',", _model.BA012);
strSql.AppendFormat("BA013='{0}',", _model.BA013);
strSql.AppendFormat("BA014='{0}',", _model.BA014);
strSql.AppendFormat("BA051='{0}',", _model.BA051);
strSql.AppendFormat("BA052='{0}',", _model.BA052);
strSql.AppendFormat("BA053='{0}',", _model.BA053);
strSql.AppendFormat("BA054='{0}',", _model.BA054);
strSql.AppendFormat("BA059='{0}',", _model.BA059);
strSql.AppendFormat("BA060='{0}'", _model.BA060);
strSql.AppendFormat(" WHERE BA003='{1}' AND idx='{0}'", _model.IDX, _model.BA003);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void assign( )
{
_model = _bll.GetModel(_model.IDX);
if (_model == null)
{
return;
}
textBox1.Text = _model.BA001;
textBox12.Text = _model.BA006;
textBox14.Text = _model.BA007;
textBox8.Text = _model.BA008;
textBox5.Text = _model.BA009.ToString( );
textBox6.Text = _model.BA059.ToString( );
textBox10.Text = _model.BA051;
textBox9.Text = _model.BA052;
textBox11.Text = _model.BA053;
textBox13.Text = _model.BA054.ToString( );
textBox16.Text = _model.BA010.ToString( );
textBox15.Text = _model.BA011.ToString( );
textBox17.Text = _model.BA012.ToString( );
textBox18.Text = _model.BA013.ToString( );
textBox19.Text = _model.BA060.ToString( );
if (_model.BA014 > DateTime.MinValue && _model.BA014 < DateTime.MaxValue)
{
dateTimePicker1.Value = _model.BA014;
}
textBox6.Text = _model.BA059.ToString( );
num = textBox1.Text;
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.ContractToDoAJobLibrary _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_PQBA SET ");
//strSql.AppendFormat( "BA001='{0}'," ,_model.BA001);
strSql.AppendFormat("BA002='{0}',", _model.BA002);
strSql.AppendFormat("BA004='{0}',", _model.BA004);
strSql.AppendFormat("BA005='{0}',", _model.BA005);
strSql.AppendFormat("BA015='{0}',", _model.BA015);
strSql.AppendFormat("BA016='{0}',", _model.BA016);
strSql.AppendFormat("BA017='{0}',", _model.BA017);
strSql.AppendFormat("BA018='{0}',", _model.BA018);
strSql.AppendFormat("BA019='{0}',", _model.BA019);
strSql.AppendFormat("BA020='{0}',", _model.BA020);
strSql.AppendFormat("BA021='{0}',", _model.BA021);
strSql.AppendFormat("BA022='{0}',", _model.BA022);
strSql.AppendFormat("BA023='{0}',", _model.BA023);
strSql.AppendFormat("BA024='{0}',", _model.BA024);
strSql.AppendFormat("BA025='{0}',", _model.BA025);
strSql.AppendFormat("BA026='{0}',", _model.BA026);
strSql.AppendFormat("BA027='{0}',", _model.BA027);
strSql.AppendFormat("BA028='{0}',", _model.BA028);
strSql.AppendFormat("BA029='{0}',", _model.BA029);
strSql.AppendFormat("BA030='{0}',", _model.BA030);
strSql.AppendFormat("BA031='{0}',", _model.BA031);
strSql.AppendFormat("BA032='{0}',", _model.BA032);
strSql.AppendFormat("BA033='{0}',", _model.BA033);
strSql.AppendFormat("BA034='{0}',", _model.BA034);
strSql.AppendFormat("BA035='{0}',", _model.BA035);
strSql.AppendFormat("BA036='{0}',", _model.BA036);
strSql.AppendFormat("BA037='{0}',", _model.BA037);
strSql.AppendFormat("BA038='{0}',", _model.BA038);
strSql.AppendFormat("BA039='{0}',", _model.BA039);
strSql.AppendFormat("BA040='{0}',", _model.BA040);
strSql.AppendFormat("BA041='{0}',", _model.BA041);
strSql.AppendFormat("BA042='{0}',", _model.BA042);
strSql.AppendFormat("BA043='{0}',", _model.BA043);
strSql.AppendFormat("BA044='{0}',", _model.BA044);
strSql.AppendFormat("BA045='{0}',", _model.BA045);
strSql.AppendFormat("BA046='{0}',", _model.BA046);
strSql.AppendFormat("BA047='{0}',", _model.BA047);
strSql.AppendFormat("BA048='{0}',", _model.BA048);
strSql.AppendFormat("BA049='{0}',", _model.BA049);
strSql.AppendFormat("BA050='{0}',", _model.BA050);
//strSql.AppendFormat( "BA051='{0}'," ,_model.BA051 );
//strSql.AppendFormat( "BA052='{0}'," ,_model.BA052 );
//strSql.AppendFormat( "BA053='{0}'," ,_model.BA053 );
//strSql.AppendFormat( "BA054='{0}'," ,_model.BA054 );
strSql.AppendFormat("BA056='{0}',", _model.BA056);
strSql.AppendFormat("BA057='{0}',", _model.BA057);
strSql.AppendFormat("BA058='{0}'", _model.BA058);
strSql.AppendFormat(" WHERE BA003='{0}'", _model.BA003);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Add(MulaolaoLibrary.ContractToDoAJobLibrary _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("INSERT INTO R_PQBA (");
strSql.Append("BA001,BA002,BA003,BA006,BA007,BA008,BA009,BA010,BA011,BA012,BA013,BA014,BA051,BA052,BA053,BA054,BA059,BA060)");
strSql.Append(" VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", _model.BA001, _model.BA002, _model.BA003, _model.BA006, _model.BA007, _model.BA008, _model.BA009, _model.BA010, _model.BA011, _model.BA012, _model.BA013, _model.BA014, _model.BA051, _model.BA052, _model.BA053, _model.BA054, _model.BA059, _model.BA060);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, _model.BA003, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
protected override void select( )
{
base.select( );
_model = new MulaolaoLibrary.ContractToDoAJobLibrary( );
query.PassDataBetweenForm += new SelectAll.ContracToDoAJobAll.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.StartPosition = FormStartPosition.CenterScreen;
query.ShowDialog( );
if (_model.BA003 != null)
{
autoQuery( );
}
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.ContractToDoAJobLibrary _model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
return(_dao.Update(_model, tableNum, tableName, logins, dtOne, stateOf, stateOfOdd));
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.ContractToDoAJobLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.ContractToDoAJobLibrary _model = new MulaolaoLibrary.ContractToDoAJobLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
_model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["BA001"] != null && row["BA001"].ToString( ) != "")
{
_model.BA001 = row["BA001"].ToString( );
}
if (row["BA002"] != null && row["BA002"].ToString( ) != "")
{
_model.BA002 = row["BA002"].ToString( );
}
if (row["BA003"] != null && row["BA003"].ToString( ) != "")
{
_model.BA003 = row["BA003"].ToString( );
}
if (row["BA004"] != null && row["BA004"].ToString( ) != "")
{
_model.BA004 = row["BA004"].ToString( );
}
if (row["BA005"] != null && row["BA005"].ToString( ) != "")
{
_model.BA005 = row["BA005"].ToString( );
}
if (row["BA006"] != null && row["BA006"].ToString( ) != "")
{
_model.BA006 = row["BA006"].ToString( );
}
if (row["BA007"] != null && row["BA007"].ToString( ) != "")
{
_model.BA007 = row["BA007"].ToString( );
}
if (row["BA008"] != null && row["BA008"].ToString( ) != "")
{
_model.BA008 = row["BA008"].ToString( );
}
if (row["BA009"] != null && row["BA009"].ToString( ) != "")
{
_model.BA009 = decimal.Parse(row["BA009"].ToString( ));
}
if (row["BA010"] != null && row["BA010"].ToString( ) != "")
{
_model.BA010 = decimal.Parse(row["BA010"].ToString( ));
}
if (row["BA011"] != null && row["BA011"].ToString( ) != "")
{
_model.BA011 = decimal.Parse(row["BA011"].ToString( ));
}
if (row["BA012"] != null && row["BA012"].ToString( ) != "")
{
_model.BA012 = decimal.Parse(row["BA012"].ToString( ));
}
if (row["BA013"] != null && row["BA013"].ToString( ) != "")
{
_model.BA013 = decimal.Parse(row["BA013"].ToString( ));
}
if (row["BA014"] != null && row["BA014"].ToString( ) != "")
{
_model.BA014 = DateTime.Parse(row["BA014"].ToString( ));
}
if (row["BA015"] != null && row["BA015"].ToString( ) != "")
{
_model.BA015 = row["BA015"].ToString( );
}
if (row["BA016"] != null && row["BA016"].ToString( ) != "")
{
_model.BA016 = row["BA016"].ToString( );
}
if (row["BA017"] != null && row["BA017"].ToString( ) != "")
{
_model.BA017 = row["BA017"].ToString( );
}
if (row["BA018"] != null && row["BA018"].ToString( ) != "")
{
_model.BA018 = row["BA018"].ToString( );
}
if (row["BA019"] != null && row["BA019"].ToString( ) != "")
{
_model.BA019 = int.Parse(row["BA019"].ToString( ));
}
if (row["BA020"] != null && row["BA020"].ToString( ) != "")
{
_model.BA020 = row["BA020"].ToString( );
}
if (row["BA021"] != null && row["BA021"].ToString( ) != "")
{
_model.BA021 = row["BA021"].ToString( );
}
if (row["BA022"] != null && row["BA022"].ToString( ) != "")
{
_model.BA022 = row["BA022"].ToString( );
}
if (row["BA023"] != null && row["BA023"].ToString( ) != "")
{
_model.BA023 = row["BA023"].ToString( );
}
if (row["BA024"] != null && row["BA024"].ToString( ) != "")
{
_model.BA024 = row["BA024"].ToString( );
}
if (row["BA025"] != null && row["BA025"].ToString( ) != "")
{
_model.BA025 = row["BA025"].ToString( );
}
if (row["BA026"] != null && row["BA026"].ToString( ) != "")
{
_model.BA026 = row["BA026"].ToString( );
}
if (row["BA027"] != null && row["BA027"].ToString( ) != "")
{
_model.BA027 = row["BA027"].ToString( );
}
if (row["BA028"] != null && row["BA028"].ToString( ) != "")
{
_model.BA028 = row["BA028"].ToString( );
}
if (row["BA029"] != null && row["BA029"].ToString( ) != "")
{
_model.BA029 = row["BA029"].ToString( );
}
if (row["BA030"] != null && row["BA030"].ToString( ) != "")
{
_model.BA030 = row["BA030"].ToString( );
}
if (row["BA031"] != null && row["BA031"].ToString( ) != "")
{
_model.BA031 = row["BA031"].ToString( );
}
if (row["BA032"] != null && row["BA032"].ToString( ) != "")
{
_model.BA032 = row["BA032"].ToString( );
}
if (row["BA033"] != null && row["BA033"].ToString( ) != "")
{
_model.BA033 = DateTime.Parse(row["BA033"].ToString( ));
}
if (row["BA034"] != null && row["BA034"].ToString( ) != "")
{
_model.BA034 = row["BA034"].ToString( );
}
if (row["BA035"] != null && row["BA035"].ToString( ) != "")
{
_model.BA035 = DateTime.Parse(row["BA035"].ToString( ));
}
if (row["BA036"] != null && row["BA036"].ToString( ) != "")
{
_model.BA036 = row["BA036"].ToString( );
}
if (row["BA037"] != null && row["BA037"].ToString( ) != "")
{
_model.BA037 = DateTime.Parse(row["BA037"].ToString( ));
}
if (row["BA038"] != null && row["BA038"].ToString( ) != "")
{
_model.BA038 = row["BA038"].ToString( );
}
if (row["BA039"] != null && row["BA039"].ToString( ) != "")
{
_model.BA039 = DateTime.Parse(row["BA039"].ToString( ));
}
if (row["BA040"] != null && row["BA040"].ToString( ) != "")
{
_model.BA040 = row["BA040"].ToString( );
}
if (row["BA041"] != null && row["BA041"].ToString( ) != "")
{
_model.BA041 = DateTime.Parse(row["BA041"].ToString( ));
}
if (row["BA042"] != null && row["BA042"].ToString( ) != "")
{
_model.BA042 = row["BA042"].ToString( );
}
if (row["BA043"] != null && row["BA043"].ToString( ) != "")
{
_model.BA043 = DateTime.Parse(row["BA043"].ToString( ));
}
if (row["BA044"] != null && row["BA044"].ToString( ) != "")
{
_model.BA044 = row["BA044"].ToString( );
}
if (row["BA045"] != null && row["BA045"].ToString( ) != "")
{
_model.BA045 = row["BA045"].ToString( );
}
if (row["BA046"] != null && row["BA046"].ToString( ) != "")
{
_model.BA046 = row["BA046"].ToString( );
}
if (row["BA047"] != null && row["BA047"].ToString( ) != "")
{
_model.BA047 = row["BA047"].ToString( );
}
if (row["BA048"] != null && row["BA048"].ToString( ) != "")
{
_model.BA048 = row["BA048"].ToString( );
}
if (row["BA049"] != null && row["BA049"].ToString( ) != "")
{
_model.BA049 = row["BA049"].ToString( );
}
if (row["BA050"] != null && row["BA050"].ToString( ) != "")
{
_model.BA050 = row["BA050"].ToString( );
}
if (row["BA051"] != null && row["BA051"].ToString( ) != "")
{
_model.BA051 = row["BA051"].ToString( );
}
if (row["BA052"] != null && row["BA052"].ToString( ) != "")
{
_model.BA052 = row["BA052"].ToString( );
}
if (row["BA053"] != null && row["BA053"].ToString( ) != "")
{
_model.BA053 = row["BA053"].ToString( );
}
if (row["BA054"] != null && row["BA054"].ToString( ) != "")
{
_model.BA054 = long.Parse(row["BA054"].ToString( ));
}
if (row["BA055"] != null && row["BA055"].ToString( ) != "")
{
_model.BA055 = row["BA055"].ToString( );
}
if (row["BA056"] != null && row["BA056"].ToString( ) != "")
{
_model.BA056 = row["BA056"].ToString( );
}
if (row["BA057"] != null && row["BA057"].ToString( ) != "")
{
_model.BA057 = row["BA057"].ToString( );
}
if (row["BA058"] != null && row["BA058"].ToString( ) != "")
{
_model.BA058 = row["BA058"].ToString( );
}
if (row["BA059"] != null && row["BA059"].ToString( ) != "")
{
_model.BA059 = decimal.Parse(row["BA059"].ToString( ));
}
if (row["BA060"] != null && row["BA060"].ToString( ) != "")
{
_model.BA060 = decimal.Parse(row["BA060"].ToString( ));
}
}
return(_model);
}
void queryContent( )
{
_model = _bll.GetModel(_model.BA003);
if (_model == null)
{
return;
}
if (contract != null && contract.Rows.Count > 0)
{
if (contract.Select("DBA001='" + _model.BA002 + "'").Length > 0)
{
lookUpEdit1.Text = contract.Select("DBA001='" + _model.BA002 + "'")[0]["DBA002"].ToString( );
}
}
textBox2.Text = _model.BA004;
textBox4.Text = _model.BA005;
checkBox1.Checked = _model.BA015.Trim( ) == "T" ? true : false;
checkBox2.Checked = _model.BA016.Trim( ) == "T" ? true : false;
checkBox3.Checked = _model.BA017.Trim( ) == "T" ? true : false;
checkBox4.Checked = _model.BA018.Trim( ) == "T" ? true : false;
textBox20.Text = _model.BA019.ToString( );
checkBox5.Checked = _model.BA020.Trim( ) == "T" ? true : false;
checkBox6.Checked = _model.BA021.Trim( ) == "T" ? true : false;
checkBox7.Checked = _model.BA022.Trim( ) == "T" ? true : false;
checkBox8.Checked = _model.BA023.Trim( ) == "T" ? true : false;
checkBox9.Checked = _model.BA024.Trim( ) == "T" ? true : false;
checkBox10.Checked = _model.BA025.Trim( ) == "T" ? true : false;
checkBox11.Checked = _model.BA026.Trim( ) == "T" ? true : false;
checkBox12.Checked = _model.BA027.Trim( ) == "T" ? true : false;
checkBox13.Checked = _model.BA028.Trim( ) == "T" ? true : false;
checkBox14.Checked = _model.BA029.Trim( ) == "T" ? true : false;
checkBox15.Checked = _model.BA030.Trim( ) == "T" ? true : false;
checkBox16.Checked = _model.BA031.Trim( ) == "T" ? true : false;
textBox23.Text = _model.BA032;
if (_model.BA033 > DateTime.MinValue && _model.BA033 < DateTime.MaxValue)
{
dateTimePicker2.Value = _model.BA033;
}
else
{
dateTimePicker2.Value = DateTime.Now;
}
textBox26.Text = _model.BA034;
if (_model.BA035 > DateTime.MinValue && _model.BA035 < DateTime.MaxValue)
{
dateTimePicker3.Value = _model.BA035;
}
else
{
dateTimePicker3.Value = DateTime.Now;
}
textBox28.Text = _model.BA036;
if (_model.BA037 > DateTime.MinValue && _model.BA037 < DateTime.MaxValue)
{
dateTimePicker4.Value = _model.BA037;
}
else
{
dateTimePicker4.Value = DateTime.Now;
}
textBox30.Text = _model.BA038;
if (_model.BA039 > DateTime.MinValue && _model.BA039 < DateTime.MaxValue)
{
dateTimePicker5.Value = _model.BA039;
}
else
{
dateTimePicker5.Value = DateTime.Now;
}
textBox32.Text = _model.BA040;
if (_model.BA041 > DateTime.MinValue && _model.BA041 < DateTime.MaxValue)
{
dateTimePicker6.Value = _model.BA041;
}
else
{
dateTimePicker6.Value = DateTime.Now;
}
textBox34.Text = _model.BA042;
if (_model.BA043 > DateTime.MinValue && _model.BA043 < DateTime.MaxValue)
{
_model.BA043 = dateTimePicker7.Value;
}
else
{
dateTimePicker7.Value = DateTime.Now;
}
comboBox8.Text = _model.BA044;
comboBox9.Text = _model.BA045;
comboBox10.Text = _model.BA046;
comboBox11.Text = _model.BA047;
comboBox12.Text = _model.BA048;
textBox3.Text = _model.BA049;
textBox10.Text = _model.BA051;
textBox9.Text = _model.BA052;
textBox11.Text = _model.BA053;
checkBox17.Checked = _model.BA056.Trim( ) == "T" ? true : false;
lookUpEdit2.Text = _model.BA057;
checkBox18.Checked = _model.BA058.Trim( ) == "T" ? true : false;
button6_Click(null, null);
}
