private static SqlParameter[] GetParameters(M_ChangeProduct Cashinfo, int type)
{
SqlParameter[] parameter = new SqlParameter[] { };
switch (type)
{
case 1:
parameter = new SqlParameter[4];
parameter[0] = new SqlParameter("@prodID", SqlDbType.Int);
parameter[1] = new SqlParameter("@ExChangeID", SqlDbType.NVarChar, 200);
parameter[2] = new SqlParameter("@PState", SqlDbType.Money, 8);
parameter[3] = new SqlParameter("@num", SqlDbType.NVarChar, 200);
parameter[0].Value = Cashinfo.prodID;
parameter[1].Value = Cashinfo.ExChangeID;
parameter[2].Value = Cashinfo.PState;
parameter[3].Value = Cashinfo.num;
break;
case 2:
break;
case 3:
break;
}
return(parameter);
}
public bool Add(M_ChangeProduct card)
{
string strSql = "insert into ZL_ChangeProduct (prodID,ExChangeID,PState,num) values (@prodID,@ExChangeID,@PState,@num)";
SqlParameter[] sp = GetParameters(card, 1);
return(SqlHelper.ExecuteSql(strSql, sp));
}
public bool UpProductNum(M_ChangeProduct c)
{
string strSql = "Update ZL_ChangeProduct set num=@num Where P_ID=@P_ID";
SqlParameter[] parameter = new SqlParameter[] { };
parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@P_ID", SqlDbType.Int);
parameter[1] = new SqlParameter("@num", SqlDbType.Int);
parameter[0].Value = c.P_ID;
parameter[1].Value = c.num;
return(SqlHelper.ExecuteSql(strSql, parameter));
}
public int insert(M_ChangeProduct model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool UpdateByID(M_ChangeProduct model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.P_ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
