private static void SaveCategory(List <CreateCategoryData> CreateCategoryData, CreateFormulaData CreateFormulaData, SetdbnameResult dbname, int i, string sflg, string isbool, string Categoryid, string iscz)
{
var dbnameid = service.Setdbdata_json("", "", Categoryid, CreateFormulaData.data[i], dbname.id, CreateFormulaData.hotelcode, CreateFormulaData.pro_arr);
if (dbnameid.IndexOf("success") > -1)
{
var cateint = int.Parse(Categoryid);
iticketdb.dbdata_t.Add(new dbdata_t
{
CategoryId = cateint,
dbnameid = int.Parse(dbname.id),
hotelcode = CreateFormulaData.hotelcode,
num = int.Parse(CreateFormulaData.data[i]),
oid = CreateFormulaData.usercode,
});
iticketdb.Category_t.Add(new Category_t
{
addtime = DateTime.Now,
BeginString = "00",
bgpic = "",
Categorycode = CreateCategoryData[i].cate_code,
CategoryId = cateint,
CategoryName = CreateCategoryData[i].cate_name,
CategoryNamebm = CreateCategoryData[i].cate_bm,
dzpq = "1",
endnum = int.Parse("00"),
EndString = "00",
ExpireDate = CreateCategoryData[i].cate_start_date.ToString(),
ExpireDateend = (CreateCategoryData[i].cate_start_date + CreateCategoryData[i].cate_end_date).ToString(),
flag = 0,
fmoney = CreateCategoryData[i].cate_price == "" ? decimal.Parse("9999") : decimal.Parse(CreateCategoryData[i].cate_price),
fnum = 0,
hotelcode = CreateFormulaData.hotelcode,
HotelId = CreateFormulaData.hotelcode,
isbool = int.Parse(isbool),//未确定
iscz = int.Parse(iscz),
istest = 0,
iswxly = 0,
iszs = CreateCategoryData[i].iszs == null ? 1 : int.Parse(CreateCategoryData[i].iszs),
maxNum = int.Parse(CreateFormulaData.pro_num == "" ? "999999" : CreateFormulaData.pro_num),
moneytype = 0,
pic = "",
rate = 1,
sflag = int.Parse(sflg),
Summary = CreateCategoryData[i].cate_summary,
type = 0,
});
var setcatefw = service.Setcategory_fw_pl_json("", "", Categoryid, CreateFormulaData.hotelcode_fw, CreateFormulaData.pro_arr);
var rangArr = CreateFormulaData.hotelcode_fw.Split(',');
foreach (var item1 in rangArr)
{
if (item1.ToString() != "")
{
if (!iticketdb.Category_fw_t.Any(x => x.hotelcode == CreateFormulaData.hotelcode && x.CategoryId == cateint))
{
iticketdb.Category_fw_t.Add(new Category_fw_t
{
CategoryId = cateint,
hotelcode = CreateFormulaData.hotelcode,
usehotelcode = item1.ToString(),
addtime = DateTime.Now,
});
}
}
}
iticketdb.SaveChanges();
}
}
public static bool CreateCategory(List <CreateCategoryData> CreateCategoryData, CreateFormulaData CreateFormulaData, SetdbnameResult dbname)
{
var isSet = true;
try
{
for (int i = 0; i < CreateCategoryData.Count; i++)
{
if (CreateCategoryData[i].cate_name != null)
{
var sflg = TicketApi.GetSflag(CreateFormulaData.type, CreateCategoryData[i].cate_xz, CreateCategoryData[i].cate_type);
var iscz = TicketApi.GetIscz(sflg);
if (sflg == "4" || sflg == "5")
{
var isbool = TicketApi.GetIsBool(sflg, CreateCategoryData[i].isbool);
var Categoryid = service.Setcategory_cz_json
("", "", CreateCategoryData[i].cate_name, CreateCategoryData[i].cate_code, CreateCategoryData[i].cate_summary, CreateFormulaData.hotelcode, "", "00", "00", "0", CreateCategoryData[i].cate_type, sflg, CreateCategoryData[i].cate_start_date.ToString(), (CreateCategoryData[i].cate_start_date + CreateCategoryData[i].cate_end_date).ToString(), "00", "1", isbool, "0", "1", CreateCategoryData[i].cate_bm, CreateCategoryData[i].cate_price, "0", CreateCategoryData[i].iszs, iscz, "", CreateFormulaData.pro_arr);
if (Categoryid != "")
{
SaveCategory(CreateCategoryData, CreateFormulaData, dbname, i, sflg, isbool, Categoryid, iscz);
}
else
{
isSet = false;
}
}
else
{
var isbool = TicketApi.GetIsBool(sflg, CreateCategoryData[i].isbool);
var Categoryid = service.Setcategory_json("", "", CreateCategoryData[i].cate_name, CreateCategoryData[i].cate_code, CreateCategoryData[i].cate_summary, CreateFormulaData.hotelcode, "", "00", "00", "0", CreateCategoryData[i].cate_type, sflg, CreateCategoryData[i].cate_start_date.ToString(), (CreateCategoryData[i].cate_start_date + CreateCategoryData[i].cate_end_date).ToString(), "00", "1", isbool, "0", "1", CreateCategoryData[i].cate_bm, CreateCategoryData[i].cate_price == "" ? "9999" : CreateCategoryData[i].cate_price, "0", CreateCategoryData[i].iszs, iscz, CreateFormulaData.pro_arr);
if (Categoryid != "")
{
SaveCategory(CreateCategoryData, CreateFormulaData, dbname, i, sflg, isbool, Categoryid, iscz);
}
else
{
isSet = false;
}
}
}
}
}
catch (Exception ex)
{
isSet = false;
}
return(isSet);
}
