/// <summary>
/// 应用套餐
/// </summary>
/// <param name="serviceType"></param>
private void ApplyCombo(string serviceType)
{
DataTable dt_cb02 = new DataTable();
OracleDataAdapter cb02Adapter = new OracleDataAdapter("select * from cb02 where cb001=(select cb001 from cb01 where cb002 = '0' and cb005 = :service)", SqlHelper.conn);
OracleParameter op_service = new OracleParameter("service", OracleDbType.Varchar2, 3);
op_service.Direction = ParameterDirection.Input;
cb02Adapter.SelectCommand.Parameters.Add(op_service);
op_service.Value = serviceType;
cb02Adapter.Fill(dt_cb02);
/////循环处理套餐明细
foreach (DataRow dr in dt_cb02.Rows)
{ ///如果套餐明细项目不存在!
if (!FireAction.ItemIsExisted(ac01.AC001, dr["CB022"].ToString(), dr["CB021"].ToString()))
{
SA01 sa01 = new SA01(unitOfWork1);
sa01.SA001 = MiscAction.GetEntityPK("SA01");
sa01.AC001 = ac01.AC001;
sa01.SA002 = dr["CB022"].ToString(); //类型
sa01.SA003 = FireAction.GetItemName(dr["CB021"].ToString());
sa01.SA004 = dr["CB021"].ToString();
sa01.SA005 = "0";
sa01.PRICE = FireAction.GetItemPrice(dr["CB021"].ToString());
sa01.NUMS = Convert.ToInt32(dr["CB030"]);
sa01.SA007 = sa01.PRICE * sa01.NUMS;
sa01.SA006 = sa01.PRICE;
sa01.SA008 = "0";
sa01.SA100 = Envior.cur_user.UC001;
sa01.SA200 = MiscAction.GetServerTime();
sa01.STATUS = "1";
}
}
}
