/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.DailyUseOfChemicals _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("INSERT INTO R_PQAG (");
strSql.Append("AG001,AG002,AG003,AG005,AG006,AG007,AG008,AG009,AG010,AG011,AG012,AG013,AG014,AG016,AG019,AG020)");
strSql.Append(" VALUES (");
strSql.Append("@AG001,@AG002,@AG003,@AG005,@AG006,@AG007,@AG008,@AG009,@AG010,@AG011,@AG012,@AG013,@AG014,@AG016,@AG019,@AG020);");
strSql.Append("SELECT SCOPE_IDENTITY();");
SqlParameter[] parameter =
{
new SqlParameter("@AG001", SqlDbType.NVarChar, 20),
new SqlParameter("@AG002", SqlDbType.NVarChar, 20),
new SqlParameter("@AG003", SqlDbType.Date),
new SqlParameter("@AG005", SqlDbType.NVarChar, 20),
new SqlParameter("@AG006", SqlDbType.NVarChar, 20),
new SqlParameter("@AG007", SqlDbType.NVarChar, 20),
new SqlParameter("@AG008", SqlDbType.NVarChar, 255),
new SqlParameter("@AG009", SqlDbType.NVarChar, 20),
new SqlParameter("@AG010", SqlDbType.NVarChar, 255),
new SqlParameter("@AG011", SqlDbType.Decimal, 3),
new SqlParameter("@AG012", SqlDbType.Decimal, 3),
new SqlParameter("@AG013", SqlDbType.Decimal, 3),
new SqlParameter("@AG014", SqlDbType.Decimal, 3),
new SqlParameter("@AG016", SqlDbType.NVarChar, 20),
new SqlParameter("@AG019", SqlDbType.NVarChar, 10),
new SqlParameter("@AG020", SqlDbType.NVarChar, 20)
};
parameter[0].Value = _model.AG001;
parameter[1].Value = _model.AG002;
parameter[2].Value = _model.AG003;
parameter[3].Value = _model.AG005;
parameter[4].Value = _model.AG006;
parameter[5].Value = _model.AG007;
parameter[6].Value = _model.AG008;
parameter[7].Value = _model.AG009;
parameter[8].Value = _model.AG010;
parameter[9].Value = _model.AG011;
parameter[10].Value = _model.AG012;
parameter[11].Value = _model.AG013;
parameter[12].Value = _model.AG014;
parameter[13].Value = _model.AG016;
parameter[14].Value = _model.AG019;
parameter [15].Value = _model.AG020;
return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameter));
}
/// <summary>
/// 编辑一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public bool Update(MulaolaoLibrary.DailyUseOfChemicals _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAG SET ");
strSql.Append("AG002=@AG002,");
strSql.Append("AG003=@AG003,");
strSql.Append("AG005=@AG005,");
strSql.Append("AG006=@AG006,");
strSql.Append("AG007=@AG007,");
strSql.Append("AG008=@AG008,");
strSql.Append("AG009=@AG009,");
strSql.Append("AG010=@AG010,");
strSql.Append("AG011=@AG011,");
strSql.Append("AG012=@AG012,");
strSql.Append("AG013=@AG013,");
strSql.Append("AG014=@AG014,");
strSql.Append("AG016=@AG016,");
strSql.Append("AG019=@AG019,");
strSql.Append("AG020=@AG020 ");
strSql.Append(" WHERE idx=@idx");
SqlParameter[] parameter =
{
new SqlParameter("@AG002", SqlDbType.NVarChar, 20),
new SqlParameter("@AG003", SqlDbType.Date),
new SqlParameter("@AG005", SqlDbType.NVarChar, 20),
new SqlParameter("@AG006", SqlDbType.NVarChar, 20),
new SqlParameter("@AG007", SqlDbType.NVarChar, 20),
new SqlParameter("@AG008", SqlDbType.NVarChar, 255),
new SqlParameter("@AG009", SqlDbType.NVarChar, 20),
new SqlParameter("@AG010", SqlDbType.NVarChar, 255),
new SqlParameter("@AG011", SqlDbType.Decimal, 3),
new SqlParameter("@AG012", SqlDbType.Decimal, 3),
new SqlParameter("@AG013", SqlDbType.Decimal, 3),
new SqlParameter("@AG014", SqlDbType.Decimal, 3),
new SqlParameter("@AG016", SqlDbType.NVarChar, 20),
new SqlParameter("@AG019", SqlDbType.NVarChar, 10),
new SqlParameter("@AG020", SqlDbType.NVarChar, 20),
new SqlParameter("@idx", SqlDbType.Int)
};
parameter[0].Value = _model.AG002;
parameter[1].Value = _model.AG003;
parameter[2].Value = _model.AG005;
parameter[3].Value = _model.AG006;
parameter[4].Value = _model.AG007;
parameter[5].Value = _model.AG008;
parameter[6].Value = _model.AG009;
parameter[7].Value = _model.AG010;
parameter[8].Value = _model.AG011;
parameter[9].Value = _model.AG012;
parameter[10].Value = _model.AG013;
parameter[11].Value = _model.AG014;
parameter[12].Value = _model.AG016;
parameter[13].Value = _model.AG019;
parameter [14].Value = _model.AG020;
parameter [15].Value = _model.IDX;
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 Update(MulaolaoLibrary.DailyUseOfChemicals _model)
{
return(_dao.Update(_model));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
public int Add(MulaolaoLibrary.DailyUseOfChemicals _model)
{
return(_dao.Add(_model));
}
