/// <summary> /// 从PRODUCT00中查找每一产品的所有信息 /// </summary> /// <param name="saleTemp01">传过来一个SALETMP01实体</param> /// <returns>返回一个DataSet数据集</returns> public DataSet SelectProInfo(SALETMP01 saleTemp01) { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@PROD_ID", SqlDbType.NVarChar, 10); para[0].Value = saleTemp01.PROD_ID1; string sql = "SELECT * FROM PRODUCT00 WHERE PROD_ID = @PROD_ID"; return(base.CreateDataSet(sql, para)); }
/// <summary> /// 对SALETMP01表中的产品的对应单个产品价格做改动时经手员工编号FREE_EMP字段的修改 /// </summary> /// <param name="saleTemp01">传过来一个SALETMP01实体</param> /// <returns>返回true或false</returns> public bool UpdateSALETMP01FREE_EMP(SALETMP01 saleTemp01) { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@GROUP_PROD", SqlDbType.NVarChar, 400); para[0].Value = saleTemp01.GROUP_PROD1; string sql1 = "Update SALETMP01 set FREE_EMP='" + saleTemp01.FREE_EMP1 + "'" + "where SHOP_ID= " + "'" + saleTemp01.SHOP_ID1 + "'" + " " + "and SALE_ID=" + "'" + saleTemp01.SALE_ID1 + "'" + " " + "and GROUP_PROD= @GROUP_PROD"; return(base.RunSQL(sql1, para)); }
/// <summary> /// 获得默认子产品价格和 /// </summary> /// <param name="saletmp01">传过来一个SALETMP01实体</param> /// <returns>默认子产品价格和</returns> public decimal ReturnDefaultprice(SALETMP01 saletmp01) { string sql = "select sum(price*quantity) as 差价 from combination where comb_id='" + saletmp01.COMB_ID1 + "' and isdefault='1'"; try { return(Convert.ToDecimal(base.CreateDataSet(sql).Tables[0].Rows[0]["差价"].ToString())); } catch { return(0); } }
/// <summary> /// 从COMBINATION和PRODUCT00中查找每一组合餐的所有信息 /// </summary> /// <param name="saleTemp01">传过来一个SALETMP01实体</param> /// <returns>返回一个DataSet数据集</returns> public DataSet SelectSaleCombInfo(SALETMP01 saleTemp01) { SqlParameter[] para = new SqlParameter[2]; para[0] = new SqlParameter("@COMB_ID", SqlDbType.NVarChar, 10); para[1] = new SqlParameter("@PROD_ID", SqlDbType.NVarChar, 10); para[0].Value = saleTemp01.COMB_ID1; para[1].Value = saleTemp01.PROD_ID1; string sql = "SELECT COMBINATION.*, PRODUCT00.* FROM COMBINATION INNER JOIN PRODUCT00 ON COMBINATION.PROD_ID = PRODUCT00.PROD_ID WHERE (COMBINATION.COMB_ID = @COMB_ID) AND (COMBINATION.PROD_ID= @PROD_ID) and COMB_SNO=" + saleTemp01.COMB_SNO1; return(base.CreateDataSet(sql, para)); }
/// <summary> /// 向SALETMP01表插入数据 /// </summary> /// <param name="saleTemp01">传过来一个SALETMP01实体</param> /// <returns>返回true或false</returns> public bool insertSaleTemp01(SALETMP01 saleTemp01) { SqlParameter[] para = new SqlParameter[23]; para[0] = new SqlParameter("@SHOP_ID", SqlDbType.NVarChar, 12); para[1] = new SqlParameter("@SALE_ID", SqlDbType.NVarChar, 32); para[2] = new SqlParameter("@SALE_SNO", SqlDbType.SmallInt); para[3] = new SqlParameter("@PROD_ID", SqlDbType.NVarChar, 20); para[4] = new SqlParameter("@SALE_PRICE", SqlDbType.Money); para[5] = new SqlParameter("@QTY", SqlDbType.Decimal); para[6] = new SqlParameter("@ITEM_DISC", SqlDbType.Money); para[7] = new SqlParameter("@PRICE_TYPE", SqlDbType.NChar, 1); //para[8] = new SqlParameter("@FREE_EMP", SqlDbType.NVarChar, 10); //para[9] = new SqlParameter("@FREE_MEMO", SqlDbType.NVarChar, 100); para[8] = new SqlParameter("@COMB_TYPE", SqlDbType.NChar, 1); para[9] = new SqlParameter("@ITEM_TAX", SqlDbType.Money); para[10] = new SqlParameter("@MEAL_TICKET", SqlDbType.Int); para[11] = new SqlParameter("@RELATE_PROD", SqlDbType.NVarChar, 20); para[12] = new SqlParameter("@ITEM_DISC_TOT", SqlDbType.Decimal); para[13] = new SqlParameter("@ACT_PRICE", SqlDbType.Decimal); para[14] = new SqlParameter("@GROUP_PROD", SqlDbType.NVarChar, 400); para[15] = new SqlParameter("@STATUS_ID", SqlDbType.NChar, 1); para[16] = new SqlParameter("@COMB_SNO", SqlDbType.SmallInt); para[17] = new SqlParameter("@SALE_ORGINAL_PRICE", SqlDbType.Decimal); para[18] = new SqlParameter("@BY_TOKEN", SqlDbType.Bit); para[19] = new SqlParameter("@ISPROM", SqlDbType.Bit); para[20] = new SqlParameter("@OUTINCOME", SqlDbType.Bit); para[21] = new SqlParameter("@COMB_SALE_SNO", SqlDbType.SmallInt); para[22] = new SqlParameter("@TRANSFER_STATUS", SqlDbType.NVarChar); para[0].Value = saleTemp01.SHOP_ID1; para[1].Value = saleTemp01.SALE_ID1; para[2].Value = saleTemp01.SALE_SNO1; para[3].Value = saleTemp01.PROD_ID1; para[4].Value = saleTemp01.SALE_PRICE1; para[5].Value = saleTemp01.QTY1; para[6].Value = saleTemp01.ITEM_DISC1; para[7].Value = saleTemp01.PRICE_TYPE1; //para[8].Value = ""; //para[9].Value = ""; para[8].Value = saleTemp01.COMB_TYPE1; para[9].Value = 0; para[10].Value = saleTemp01.MEAL_TICKET1; para[11].Value = saleTemp01.RELATE_PROD1; para[12].Value = saleTemp01.ITEM_DISC_TOT1; para[13].Value = saleTemp01.ACT_PRICE1; para[14].Value = saleTemp01.GROUP_PROD1; para[15].Value = 2; para[16].Value = saleTemp01.COMB_SNO1; para[17].Value = saleTemp01.SALE_ORGINAL_PRICE1; para[18].Value = Convert.ToBoolean(0); para[19].Value = saleTemp01.ISPROM1; para[20].Value = Convert.ToBoolean(0); para[21].Value = saleTemp01.COMB_SALE_SNO1; para[22].Value = "0"; if (saleTemp01.COMB_TYPE1 == "1") { para[21].Value = DBNull.Value; } string sql = "insert SALETMP01(SHOP_ID, SALE_ID, SALE_SNO, PROD_ID, SALE_PRICE, QTY, ITEM_DISC, PRICE_TYPE, COMB_TYPE , ITEM_TAX, MEAL_TICKET, RELATE_PROD, ITEM_DISC_TOT, ACT_PRICE ,GROUP_PROD, STATUS_ID, COMB_SNO,SALE_ORGINAL_PRICE,BY_TOKEN,ISPROM,OUTINCOME,COMB_SALE_SNO,TRANSFER_STATUS) values(@SHOP_ID, @SALE_ID, @SALE_SNO, @PROD_ID, @SALE_PRICE, @QTY, @ITEM_DISC, @PRICE_TYPE, @COMB_TYPE, @ITEM_TAX, @MEAL_TICKET, @RELATE_PROD, @ITEM_DISC_TOT, @ACT_PRICE ,@GROUP_PROD, @STATUS_ID, @COMB_SNO,@SALE_ORGINAL_PRICE,@BY_TOKEN,@ISPROM,@OUTINCOME,@COMB_SALE_SNO,@TRANSFER_STATUS)"; bool a; a = base.RunSQL(sql, para); return(a); }
/// <summary> /// 对SALETMP01表中的产品的对应单个产品价格做改动时经手员工编号FREE_EMP字段的修改 /// </summary> /// <param name="saleTemp01">传过来一个SALETMP01实体</param> public void setSaleTemp01Free_Emp(SALETMP01 saleTemp01) { DataUpdateSales.InitDataUpdateSales().UpdateSALETMP01FREE_EMP(saleTemp01); }