/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateWeiHu(MulaolaoLibrary.GongZiCeLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEZ SET ");
strSql.Append("EZ012=@EZ012,");
strSql.Append("EZ013=@EZ013");
strSql.Append(" WHERE EZ001=@EZ001");
SqlParameter[] parameter =
{
new SqlParameter("@EZ012", SqlDbType.NVarChar),
new SqlParameter("@EZ013", SqlDbType.NVarChar),
new SqlParameter("@EZ001", SqlDbType.NVarChar)
};
parameter[0].Value = model.EZ012;
parameter[1].Value = model.EZ013;
parameter[2].Value = model.EZ001;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateIdx(MulaolaoLibrary.GongZiCeLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQEZ SET ");
strSql.Append("EZ002=@EZ002,");
strSql.Append("EZ003=@EZ003,");
strSql.Append("EZ004=@EZ004,");
strSql.Append("EZ005=@EZ005,");
strSql.Append("EZ006=@EZ006,");
strSql.Append("EZ007=@EZ007,");
strSql.Append("EZ008=@EZ008,");
strSql.Append("EZ009=@EZ009,");
strSql.Append("EZ010=@EZ010,");
strSql.Append("EZ011=@EZ011,");
strSql.Append("EZ014=@EZ014");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@EZ002", SqlDbType.NVarChar),
new SqlParameter("@EZ003", SqlDbType.NVarChar),
new SqlParameter("@EZ004", SqlDbType.NVarChar),
new SqlParameter("@EZ005", SqlDbType.Decimal),
new SqlParameter("@EZ006", SqlDbType.Decimal),
new SqlParameter("@EZ007", SqlDbType.Decimal),
new SqlParameter("@EZ008", SqlDbType.Decimal),
new SqlParameter("@EZ009", SqlDbType.Decimal),
new SqlParameter("@EZ010", SqlDbType.Decimal),
new SqlParameter("@EZ011", SqlDbType.NVarChar),
new SqlParameter("@EZ014", SqlDbType.NVarChar),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = model.EZ002;
parameter[1].Value = model.EZ003;
parameter[2].Value = model.EZ004;
parameter[3].Value = model.EZ005;
parameter[4].Value = model.EZ006;
parameter[5].Value = model.EZ007;
parameter[6].Value = model.EZ008;
parameter[7].Value = model.EZ009;
parameter[8].Value = model.EZ010;
parameter[9].Value = model.EZ011;
parameter[10].Value = model.EZ014;
parameter[11].Value = model.IDX;
int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <param name="year"></param>
/// <param name="mouth"></param>
/// <returns></returns>
public bool ExistsTranInsert(MulaolaoLibrary.GongZiCeLibrary model, string year, int mouth)
{
int id = 0;
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT idx FROM R_PQW ");
strSql.Append(" WHERE GZ28=@GZ28 AND GZ30=@GZ30 AND GZ02=@GZ02 AND GZ37=@GZ37 AND GZ16=@GZ16 AND GZ44=@GZ44");
SqlParameter[] parameter =
{
//new SqlParameter("@GZ35",SqlDbType.NVarChar),
new SqlParameter("@GZ28", SqlDbType.Int),
new SqlParameter("@GZ30", SqlDbType.NVarChar),
new SqlParameter("@GZ02", SqlDbType.NVarChar),
new SqlParameter("@GZ37", SqlDbType.NVarChar),
new SqlParameter("@GZ16", SqlDbType.NVarChar),
new SqlParameter("@GZ44", SqlDbType.Int)
};
//parameter[0].Value = year;
parameter[0].Value = mouth;
parameter[1].Value = model.EZ002;
parameter[2].Value = model.EZ003;
parameter[3].Value = model.EZ014;
parameter[4].Value = model.EZ011;
parameter [5].Value = year;
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter);
StringBuilder strSqlUp = new StringBuilder( );
strSqlUp.AppendFormat("INSERT INTO R_PQEZ(EZ001,EZ002,EZ003,EZ004,EZ005,EZ006,EZ007,EZ008,EZ009,EZ010,EZ011,EZ014) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}');SELECT SCOPE_IDENTITY();", model.EZ001, model.EZ002, model.EZ003, model.EZ004, model.EZ005, model.EZ006, model.EZ007, model.EZ008, model.EZ009, model.EZ010, model.EZ011, model.EZ014);
model.IDX = SqlHelper.ExecuteSqlReturnId(strSqlUp.ToString( ));
if (model.IDX > 0)
{
for (int i = 0; i < da.Rows.Count; i++)
{
id = string.IsNullOrEmpty(da.Rows[i]["idx"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows[i]["idx"].ToString( ));
StringBuilder strSqlE = new StringBuilder( );
strSqlE.AppendFormat("SELECT COUNT(1) FROM R_PQFZ WHERE FZ001='{0}' AND FZ002='{1}'", model.IDX, id);
if (SqlHelper.Exists(strSqlE.ToString( )) == false)
{
StringBuilder strSqlIn = new StringBuilder( );
strSqlIn.AppendFormat("INSERT INTO R_PQFZ (FZ001,FZ002) VALUES ('{0}','{1}')", model.IDX, id);
SQLString.Add(strSqlIn.ToString( ));
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
else
{
return(false);
}
}
void assgien( )
{
model = bll.GetModel(model.IDX);
dateTimePicker1.Value = DateTime.ParseExact(model.EZ004 + MulaolaoBll.Drity.GetDt( ).ToString("dd"), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
textBox2.Text = model.EZ005.ToString( );
textBox3.Text = model.EZ006.ToString( );
textBox5.Text = model.EZ007.ToString( );
textBox4.Text = model.EZ008.ToString( );
textBox6.Text = model.EZ009.ToString( );
textBox7.Text = model.EZ010.ToString( );
lookUpEdit1.Text = model.EZ002;
lookUpEdit2.Text = model.EZ011;
lookUpEdit3.Text = model.EZ003;
lookUpEdit4.Text = model.EZ014;
}
/// <summary>
/// 是否存在idx
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ExistsUpIn(MulaolaoLibrary.GongZiCeLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT idx FROM R_PQEZ WHERE EZ002='{0}' AND EZ003='{1}' AND EZ004='{2}' AND EZ011='{3}'", model.EZ002, model.EZ003, model.EZ004, model.EZ011);
DataTable dr = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (dr.Rows.Count > 0)
{
model.IDX = string.IsNullOrEmpty(dr.Rows[0]["idx"].ToString( )) == true ? 0 : Convert.ToInt32(dr.Rows[0]["idx"].ToString( ));
}
else
{
model.IDX = 0;
}
return(model.IDX);
}
protected override void select( )
{
base.select( );
model = new MulaolaoLibrary.GongZiCeLibrary( );
query.StartPosition = FormStartPosition.CenterScreen;
query.PassDataBetweenForm += new SelectAll.GongZiCeAll.PassDataBetweenFormHandler(query_PassDataBetweenForm);
query.ShowDialog( );
if (string.IsNullOrEmpty(model.EZ001))
{
MessageBox.Show("您没有选择任何内容");
}
else
{
autoQuery( );
}
}
/// <summary>
/// 是否存在一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.GongZiCeLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT COUNT(1) FROM R_PQEZ");
strSql.Append(" WHERE EZ002=@EZ002 AND EZ003=@EZ003 AND EZ004=@EZ004");
SqlParameter[] parameter =
{
new SqlParameter("@EZ002", SqlDbType.NVarChar),
new SqlParameter("@EZ003", SqlDbType.NVarChar),
new SqlParameter("@EZ004", SqlDbType.NVarChar)
};
parameter[0].Value = model.EZ002;
parameter[1].Value = model.EZ003;
parameter[2].Value = model.EZ004;
return(SqlHelper.Exists(strSql.ToString( ), parameter));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.GongZiCeLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQEZ (");
strSql.Append("EZ001,EZ002,EZ003,EZ004,EZ005,EZ006,EZ007,EZ008,EZ009,EZ010,EZ011,EZ014)");
strSql.Append(" VALUES (");
strSql.Append("@EZ001,@EZ002,@EZ003,@EZ004,@EZ005,@EZ006,@EZ007,@EZ008,@EZ009,@EZ010,@EZ011,@EZ014);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter[] parameter =
{
new SqlParameter("@EZ002", SqlDbType.NVarChar),
new SqlParameter("@EZ003", SqlDbType.NVarChar),
new SqlParameter("@EZ004", SqlDbType.NVarChar),
new SqlParameter("@EZ005", SqlDbType.Decimal),
new SqlParameter("@EZ006", SqlDbType.Decimal),
new SqlParameter("@EZ007", SqlDbType.Decimal),
new SqlParameter("@EZ008", SqlDbType.Decimal),
new SqlParameter("@EZ009", SqlDbType.Decimal),
new SqlParameter("@EZ010", SqlDbType.Decimal),
new SqlParameter("@EZ011", SqlDbType.NVarChar),
new SqlParameter("@EZ001", SqlDbType.NVarChar),
new SqlParameter("@EZ014", SqlDbType.NVarChar)
};
parameter[0].Value = model.EZ002;
parameter[1].Value = model.EZ003;
parameter[2].Value = model.EZ004;
parameter[3].Value = model.EZ005;
parameter[4].Value = model.EZ006;
parameter[5].Value = model.EZ007;
parameter[6].Value = model.EZ008;
parameter[7].Value = model.EZ009;
parameter[8].Value = model.EZ010;
parameter[9].Value = model.EZ011;
parameter[10].Value = model.EZ001;
parameter[11].Value = model.EZ014;
int idx = SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter);
return(idx);
}
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateIdx(MulaolaoLibrary.GongZiCeLibrary model)
{
return(dao.UpdateIdx(model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.GongZiCeLibrary model)
{
return(dao.Add(model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <param name="year"></param>
/// <param name="mouth"></param>
/// <returns></returns>
public bool ExistsTranInsert(MulaolaoLibrary.GongZiCeLibrary model, string year, int mouth)
{
return(dao.ExistsTranInsert(model, year, mouth));
}
/// <summary>
/// 是否存在idx
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int ExistsUpIn(MulaolaoLibrary.GongZiCeLibrary model)
{
return(dao.ExistsUpIn(model));
}
/// <summary>
/// 是否存在一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Exists(MulaolaoLibrary.GongZiCeLibrary model)
{
return(dao.Exists(model));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.GongZiCeLibrary GetDataRow(DataRow row)
{
MulaolaoLibrary.GongZiCeLibrary model = new MulaolaoLibrary.GongZiCeLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["EZ001"] != null && row["EZ001"].ToString( ) != "")
{
model.EZ001 = row["EZ001"].ToString( );
}
if (row["EZ002"] != null && row["EZ002"].ToString( ) != "")
{
model.EZ002 = row["EZ002"].ToString( );
}
if (row["EZ003"] != null && row["EZ003"].ToString( ) != "")
{
model.EZ003 = row["EZ003"].ToString( );
}
if (row["EZ004"] != null && row["EZ004"].ToString( ) != "")
{
model.EZ004 = row["EZ004"].ToString( );
}
if (row["EZ005"] != null && row["EZ005"].ToString( ) != "")
{
model.EZ005 = decimal.Parse(row["EZ005"].ToString( ));
}
if (row["EZ006"] != null && row["EZ006"].ToString( ) != "")
{
model.EZ006 = decimal.Parse(row["EZ006"].ToString( ));
}
if (row["EZ007"] != null && row["EZ007"].ToString( ) != "")
{
model.EZ007 = decimal.Parse(row["EZ007"].ToString( ));
}
if (row["EZ008"] != null && row["EZ008"].ToString( ) != "")
{
model.EZ008 = decimal.Parse(row["EZ008"].ToString( ));
}
if (row["EZ009"] != null && row["EZ009"].ToString( ) != "")
{
model.EZ009 = decimal.Parse(row["EZ009"].ToString( ));
}
if (row["EZ010"] != null && row["EZ010"].ToString( ) != "")
{
model.EZ010 = decimal.Parse(row["EZ010"].ToString( ));
}
if (row["EZ011"] != null && row["EZ011"].ToString( ) != "")
{
model.EZ011 = row["EZ011"].ToString( );
}
if (row["EZ012"] != null && row["EZ012"].ToString( ) != "")
{
model.EZ012 = row["EZ012"].ToString( );
}
if (row["EZ013"] != null && row["EZ013"].ToString( ) != "")
{
model.EZ013 = row["EZ013"].ToString( );
}
if (row["EZ014"] != null && row["EZ014"].ToString( ) != "")
{
model.EZ014 = row["EZ014"].ToString( );
}
}
return(model);
}
