/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQCZ (");
strSql.Append("CZ001,CZ002,CZ003,CZ004,CZ005,CZ006)");
strSql.Append(" VALUES (");
strSql.Append(" @CZ001,@CZ002,@CZ003,@CZ004,@CZ005,@CZ006);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter[] parameter =
{
new SqlParameter("@CZ001", SqlDbType.NVarChar),
new SqlParameter("@CZ002", SqlDbType.NVarChar),
new SqlParameter("@CZ003", SqlDbType.NVarChar),
new SqlParameter("@CZ004", SqlDbType.Decimal),
new SqlParameter("@CZ005", SqlDbType.Decimal),
new SqlParameter("@CZ006", SqlDbType.NVarChar)
};
parameter[0].Value = model.CZ001;
parameter[1].Value = model.CZ002;
parameter[2].Value = model.CZ003;
parameter[3].Value = model.CZ004;
parameter[4].Value = model.CZ005;
parameter[5].Value = model.CZ006;
int idx = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
return(idx);
}
void assignMent( )
{
modelCz = bll.GetModelCz(modelCz.IDX);
lookUpEdit1.Text = textBox21.Text = modelCz.CZ001;
if (!string.IsNullOrEmpty(modelCz.CZ003))
{
dateTimePicker1.Value = dateTimePicker2.Value = DateTime.ParseExact(modelCz.CZ002 + modelCz.CZ003.Substring(2, 2), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
}
textBox20.Text = modelCz.CZ004.ToString( );
textBox5.Text = modelCz.CZ005.ToString( );
yearMonth = modelCz.CZ002;
modelDz.DZ004 = dateTimePicker1.Value.ToString("MMdd");
lookAss(modelDz.DZ004);
}
/// <summary>
/// 更改维护意见
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateWeiHu(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQCZ SET ");
strSql.Append("CZ001=@CZ001,");
strSql.Append("CZ002=@CZ002,");
strSql.Append("CZ003=@CZ003,");
strSql.Append("CZ004=@CZ004,");
strSql.Append("CZ005=@CZ005,");
strSql.Append("CZ007=@CZ007,");
strSql.Append("CZ008=@CZ008");
strSql.Append(" WHERE CZ006=@CZ006");
SqlParameter[] parameter =
{
new SqlParameter("@CZ001", SqlDbType.NVarChar),
new SqlParameter("@CZ002", SqlDbType.NVarChar),
new SqlParameter("@CZ003", SqlDbType.NVarChar),
new SqlParameter("@CZ004", SqlDbType.Decimal),
new SqlParameter("@CZ005", SqlDbType.Decimal),
new SqlParameter("@CZ006", SqlDbType.NVarChar),
new SqlParameter("@CZ007", SqlDbType.NVarChar),
new SqlParameter("@CZ008", SqlDbType.NVarChar)
};
parameter[0].Value = model.CZ001;
parameter[1].Value = model.CZ002;
parameter[2].Value = model.CZ003;
parameter[3].Value = model.CZ004;
parameter[4].Value = model.CZ005;
parameter[5].Value = model.CZ006;
parameter[6].Value = model.CZ007;
parameter[7].Value = model.CZ008;
int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="idx"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
ArrayList SQLString = new ArrayList( );
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("DELETE FROM R_PQCZ WHERE idx={0}", model.IDX);
SQLString.Add(strSql.ToString( ));
StringBuilder strD = new StringBuilder( );
strD.AppendFormat("SELECT COUNT(1) FROM R_PQDZ WHERE DZ001='{0}' AND DZ002='{1}' AND DZ003='{2}' AND DZ004='{3}'", model.CZ006, model.CZ001, model.CZ002, model.CZ003);
if (SqlHelper.Exists(strSql.ToString( )) == true)
{
StringBuilder strSqlDz = new StringBuilder( );
strSqlDz.AppendFormat("DELETE FROM R_PQDZ WHERE DZ001='{0}' AND DZ002='{1}' AND DZ003='{2}' AND DZ004='{3}'", model.CZ006, model.CZ001, model.CZ002, model.CZ003);
SQLString.Add(strSqlDz.ToString( ));
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// 获取数据集
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary GetDataRowCz(DataRow row)
{
MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model = new MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary( );
if (row != null)
{
if (row["idx"] != null && row["idx"].ToString( ) != "")
{
model.IDX = int.Parse(row["idx"].ToString( ));
}
if (row["CZ001"] != null && row["CZ001"].ToString( ) != "")
{
model.CZ001 = row["CZ001"].ToString( );
}
if (row["CZ002"] != null && row["CZ002"].ToString( ) != "")
{
model.CZ002 = row["CZ002"].ToString( );
}
if (row["CZ003"] != null && row["CZ003"].ToString( ) != "")
{
model.CZ003 = row["CZ003"].ToString( );
}
if (row["CZ004"] != null && row["CZ004"].ToString( ) != "")
{
model.CZ004 = decimal.Parse(row["CZ004"].ToString( ));
}
if (row["CZ005"] != null && row["CZ005"].ToString( ) != "")
{
model.CZ005 = decimal.Parse(row["CZ005"].ToString( ));
}
if (row["CZ006"] != null && row["CZ006"].ToString( ) != "")
{
model.CZ006 = row["CZ006"].ToString( );
}
}
return(model);
}
/// <summary>
/// 删除一条记录
/// </summary>
/// <param name="idx"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
return(dao.Delete(model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
return(dao.Add(model));
}
/// <summary>
/// 更改维护意见
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateWeiHu(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model)
{
return(dao.UpdateWeiHu(model));
}
