/// <summary>
/// 编辑记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMain(MulaolaoLibrary.DuanLiaoLibrary 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_PQIZ SET ");
strSql.AppendFormat("IZ002='{0}',", model.IZ002);
strSql.AppendFormat("IZ003='{0}',", model.IZ003);
strSql.AppendFormat("IZ004='{0}',", model.IZ004);
strSql.AppendFormat("IZ005='{0}',", model.IZ005);
strSql.AppendFormat("IZ006='{0}',", model.IZ006);
strSql.AppendFormat("IZ007='{0}',", model.IZ007);
strSql.AppendFormat("IZ023='{0}',", model.IZ023);
strSql.AppendFormat("IZ024='{0}',", model.IZ024);
strSql.AppendFormat("IZ025='{0}',", model.IZ025);
strSql.AppendFormat("IZ026='{0}',", model.IZ026);
strSql.AppendFormat("IZ027='{0}',", model.IZ027);
strSql.AppendFormat("IZ028='{0}',", model.IZ028);
strSql.AppendFormat("IZ029='{0}',", model.IZ029);
strSql.AppendFormat("IZ030='{0}',", model.IZ030);
strSql.AppendFormat("IZ031='{0}',", model.IZ031);
strSql.AppendFormat("IZ032='{0}',", model.IZ032);
strSql.AppendFormat("IZ033='{0}',", model.IZ033);
strSql.AppendFormat("IZ034='{0}',", model.IZ034);
strSql.AppendFormat("IZ035='{0}'", model.IZ035);
strSql.AppendFormat(" WHERE IZ001='{0}'", model.IZ001);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.DuanLiaoLibrary 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_PQIZ SET ");
strSql.AppendFormat("IZ005='{0}',", model.IZ005);
strSql.AppendFormat("IZ008='{0}',", model.IZ008);
strSql.AppendFormat("IZ009='{0}',", model.IZ009);
strSql.AppendFormat("IZ010='{0}',", model.IZ010);
strSql.AppendFormat("IZ011='{0}',", model.IZ011);
strSql.AppendFormat("IZ012='{0}',", model.IZ012);
strSql.AppendFormat("IZ013='{0}',", model.IZ013);
strSql.AppendFormat("IZ014='{0}',", model.IZ014);
strSql.AppendFormat("IZ015='{0}',", model.IZ015);
strSql.AppendFormat("IZ016='{0}',", model.IZ016);
strSql.AppendFormat("IZ017='{0}',", model.IZ017);
strSql.AppendFormat("IZ018='{0}',", model.IZ018);
strSql.AppendFormat("IZ019='{0}',", model.IZ019);
strSql.AppendFormat("IZ020='{0}',", model.IZ020);
strSql.AppendFormat("IZ021='{0}',", model.IZ021);
strSql.AppendFormat("IZ022='{0}'", model.IZ022);
strSql.AppendFormat(" WHERE IZ001='{1}' AND idx='{0}'", model.IDX, model.IZ001);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Insert(MulaolaoLibrary.DuanLiaoLibrary model, string tableNum, string tableName, string logins, DateTime dtOne, string stateOf, string stateOfOdd)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQIZ (");
strSql.Append("IZ001,IZ005,IZ008,IZ009,IZ010,IZ011,IZ012,IZ013,IZ014,IZ015,IZ016,IZ017,IZ018,IZ019,IZ020,IZ021,IZ022)");
strSql.Append(" VALUES (");
strSql.AppendFormat("'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}')", model.IZ001, model.IZ005, model.IZ008, model.IZ009, model.IZ010, model.IZ011, model.IZ012, model.IZ013, model.IZ014, model.IZ015, model.IZ016, model.IZ017, model.IZ018, model.IZ019, model.IZ020, model.IZ021, model.IZ022);
SQLString.Add(strSql.ToString( ));
SQLString.Add(Drity.DrityOfComparation(tableNum, tableName, logins, dtOne, model.IZ001, strSql.ToString( ).Replace("'", "''"), stateOf, stateOfOdd));
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void queryContent( )
{
if (model.IZ001 != null)
{
model = bll.GetModel(model.IZ001);
if (model == null)
{
return;
}
textBox1.Text = model.IZ002;
textBox2.Text = model.IZ003;
textBox3.Text = model.IZ004;
textBox4.Text = model.IZ034;
textBox5.Text = model.IZ005.ToString( );
textBox6.Text = model.IZ006;
textBox7.Text = model.IZ007;
textBox8.Text = model.IZ023;
textBox9.Text = model.IZ024;
comboBox4.Text = model.IZ035;
if (model.IZ025 > DateTime.MinValue && model.IZ025 < DateTime.MaxValue)
{
dateTimePicker1.Value = model.IZ025;
}
textBox10.Text = model.IZ026;
if (model.IZ027 > DateTime.MinValue && model.IZ027 < DateTime.MaxValue)
{
dateTimePicker2.Value = model.IZ027;
}
textBox11.Text = model.IZ028;
if (model.IZ029 > DateTime.MinValue && model.IZ029 < DateTime.MaxValue)
{
dateTimePicker3.Value = model.IZ029;
}
textBox12.Text = model.IZ030;
if (model.IZ031 > DateTime.MinValue && model.IZ031 < DateTime.MaxValue)
{
dateTimePicker4.Value = model.IZ031;
}
textBox13.Text = model.IZ032;
strWhere = "1=1";
strWhere = strWhere + " AND IZ001='" + model.IZ001 + "'";
button11_Click(null, null);
}
}
protected override void select( )
{
base.select( );
model = new MulaolaoLibrary.DuanLiaoLibrary( );
query.StartPosition = FormStartPosition.CenterScreen;
query.PassDataBetweenForm += new SelectAll.DuanLiaoAll.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.ShowDialog( );
if (model.IZ001 != null && model.IZ001 != "")
{
autoQuery( );
}
else
{
MessageBox.Show("您没有选择任何内容");
}
}
/// <summary>
/// 是否存在记录ss
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ExistsEdit(MulaolaoLibrary.DuanLiaoLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQIZ");
strSql.Append(" WHERE IZ002=@IZ002 AND IZ008=@IZ008 AND IZ009=@IZ009 AND IZ010=@IZ010");
SqlParameter[] parameter =
{
new SqlParameter("@IZ002", SqlDbType.NVarChar, 20),
new SqlParameter("@IZ008", SqlDbType.NVarChar, 20),
new SqlParameter("@IZ009", SqlDbType.NVarChar, 20),
new SqlParameter("@IZ010", SqlDbType.NVarChar, 20)
};
parameter[0].Value = model.IZ002;
parameter[1].Value = model.IZ008;
parameter[2].Value = model.IZ009;
parameter[3].Value = model.IZ010;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
void aessignMent( )
{
model = bll.GetModel(model.IDX);
gridLookUpEdit1.Text = model.IZ008;
comboBox2.Text = model.IZ009;
textBox21.Text = model.IZ011.ToString( );
textBox22.Text = model.IZ012;
textBox14.Text = model.IZ013.ToString( );
textBox15.Text = model.IZ014.ToString( );
textBox16.Text = model.IZ015.ToString( );
textBox17.Text = model.IZ016.ToString( );
dateTimePicker5.Value = model.IZ017;
dateTimePicker6.Value = model.IZ018;
textBox18.Text = model.IZ019.ToString( );
textBox23.Text = model.IZ020.ToString( );
textBox20.Text = model.IZ021.ToString( );
textBox19.Text = model.IZ022.ToString( );
component = gridLookUpEdit1.Text;
textBox24.Text = model.IZ010;
wood = comboBox2.Text;
specifications = textBox24.Text;
}
/// <summary>
/// 是否存在记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ExistsOf(MulaolaoLibrary.DuanLiaoLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQIZ");
strSql.Append(" WHERE IZ002=@IZ002 AND IZ008=@IZ008 AND IZ013=@IZ013 AND IZ014=@IZ014 AND IZ015=@IZ015 AND IZ006=@IZ006");
SqlParameter [] parameter =
{
new SqlParameter("@IZ002", SqlDbType.NVarChar),
new SqlParameter("@IZ008", SqlDbType.NVarChar),
new SqlParameter("@IZ013", SqlDbType.Decimal),
new SqlParameter("@IZ014", SqlDbType.Decimal),
new SqlParameter("@IZ015", SqlDbType.Decimal),
new SqlParameter("@IZ006", SqlDbType.NVarChar)
};
parameter [0].Value = model.IZ002;
parameter [1].Value = model.IZ008;
parameter [2].Value = model.IZ013;
parameter [3].Value = model.IZ014;
parameter [4].Value = model.IZ015;
parameter [5].Value = model.IZ006;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.DuanLiaoLibrary 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="model"></param>
/// <returns></returns>
public bool ExistsOf(MulaolaoLibrary.DuanLiaoLibrary model)
{
return(dao.ExistsOf(model));
}
/// <summary>
/// 获取数据实体对象
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.DuanLiaoLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.DuanLiaoLibrary model = new MulaolaoLibrary.DuanLiaoLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["IZ001"] != null && row["IZ001"].ToString( ) != "")
{
model.IZ001 = row["IZ001"].ToString( );
}
if (row["IZ002"] != null && row["IZ002"].ToString( ) != "")
{
model.IZ002 = row["IZ002"].ToString( );
}
if (row["IZ003"] != null && row["IZ003"].ToString( ) != "")
{
model.IZ003 = row["IZ003"].ToString( );
}
if (row["IZ004"] != null && row["IZ004"].ToString( ) != "")
{
model.IZ004 = row["IZ004"].ToString( );
}
if (row["IZ005"] != null && row["IZ005"].ToString( ) != "")
{
model.IZ005 = long.Parse(row["IZ005"].ToString( ));
}
if (row["IZ006"] != null && row["IZ006"].ToString( ) != "")
{
model.IZ006 = row["IZ006"].ToString( );
}
if (row["IZ007"] != null && row["IZ007"].ToString( ) != "")
{
model.IZ007 = row["IZ007"].ToString( );
}
if (row["IZ008"] != null && row["IZ008"].ToString( ) != "")
{
model.IZ008 = row["IZ008"].ToString( );
}
if (row["IZ009"] != null && row["IZ009"].ToString( ) != "")
{
model.IZ009 = row["IZ009"].ToString( );
}
if (row["IZ010"] != null && row["IZ010"].ToString( ) != "")
{
model.IZ010 = row["IZ010"].ToString( );
}
if (row["IZ011"] != null && row["IZ011"].ToString( ) != "")
{
model.IZ011 = int.Parse(row["IZ011"].ToString( ));
}
if (row["IZ012"] != null && row["IZ012"].ToString( ) != "")
{
model.IZ012 = row["IZ012"].ToString( );
}
if (row["IZ013"] != null && row["IZ013"].ToString( ) != "")
{
model.IZ013 = decimal.Parse(row["IZ013"].ToString( ));
}
if (row["IZ014"] != null && row["IZ014"].ToString( ) != "")
{
model.IZ014 = decimal.Parse(row["IZ014"].ToString( ));
}
if (row["IZ015"] != null && row["IZ015"].ToString( ) != "")
{
model.IZ015 = decimal.Parse(row["IZ015"].ToString( ));
}
if (row["IZ016"] != null && row["IZ016"].ToString( ) != "")
{
model.IZ016 = decimal.Parse(row["IZ016"].ToString( ));
}
if (row["IZ017"] != null && row["IZ017"].ToString( ) != "")
{
model.IZ017 = DateTime.Parse(row["IZ017"].ToString( ));
}
if (row["IZ018"] != null && row["IZ018"].ToString( ) != "")
{
model.IZ018 = DateTime.Parse(row["IZ018"].ToString( ));
}
if (row["IZ019"] != null && row["IZ019"].ToString( ) != "")
{
model.IZ019 = decimal.Parse(row["IZ019"].ToString( ));
}
if (row["IZ020"] != null && row["IZ020"].ToString( ) != "")
{
model.IZ020 = decimal.Parse(row["IZ020"].ToString( ));
}
if (row["IZ021"] != null && row["IZ021"].ToString( ) != "")
{
model.IZ021 = decimal.Parse(row["IZ021"].ToString( ));
}
if (row["IZ022"] != null && row["IZ022"].ToString( ) != "")
{
model.IZ022 = int.Parse(row["IZ022"].ToString( ));
}
if (row["IZ023"] != null && row["IZ023"].ToString( ) != "")
{
model.IZ023 = row["IZ023"].ToString( );
}
if (row["IZ024"] != null && row["IZ024"].ToString( ) != "")
{
model.IZ024 = row["IZ024"].ToString( );
}
if (row["IZ025"] != null && row["IZ025"].ToString( ) != "")
{
model.IZ025 = DateTime.Parse(row["IZ025"].ToString( ));
}
if (row["IZ026"] != null && row["IZ026"].ToString( ) != "")
{
model.IZ026 = row["IZ026"].ToString( );
}
if (row["IZ027"] != null && row["IZ027"].ToString( ) != "")
{
model.IZ027 = DateTime.Parse(row["IZ027"].ToString( ));
}
if (row["IZ028"] != null && row["IZ028"].ToString( ) != "")
{
model.IZ028 = row["IZ028"].ToString( );
}
if (row["IZ029"] != null && row["IZ029"].ToString( ) != "")
{
model.IZ029 = DateTime.Parse(row["IZ029"].ToString( ));
}
if (row["IZ030"] != null && row["IZ030"].ToString( ) != "")
{
model.IZ030 = row["IZ030"].ToString( );
}
if (row["IZ031"] != null && row["IZ031"].ToString( ) != "")
{
model.IZ031 = DateTime.Parse(row["IZ031"].ToString( ));
}
if (row["IZ032"] != null && row["IZ032"].ToString( ) != "")
{
model.IZ032 = row["IZ032"].ToString( );
}
if (row["IZ033"] != null && row["IZ033"].ToString( ) != "")
{
model.IZ033 = row["IZ033"].ToString( );
}
if (row["IZ034"] != null && row["IZ034"].ToString( ) != "")
{
model.IZ034 = row["IZ034"].ToString( );
}
if (row["IZ035"] != null && row["IZ035"].ToString( ) != "")
{
model.IZ035 = row["IZ035"].ToString( );
}
}
return(model);
}
