public bool BonusMasterAdd(List<BonusMasterQuery> list)
{
Serial serial = new Serial();
ArrayList arrayList = new ArrayList();
try
{
//define('SERIAL_ID_BONUS_MASTER', 27); // 購物金流水號
serial = _ISerialDao.GetSerialById(27);
for (int i = 0; i < list.Count; i++)
{
//得到+1後的serialValue,是bonus_master的master_id
serial.Serial_Value++;
list[i].master_id = Convert.ToUInt32(serial.Serial_Value);
//更新serial表
arrayList.Add(_ISerialDao.UpdateAutoIncreament(serial));
//插入BonusMaster數據
arrayList.Add(_IBonusMasterDao.InsertBonusMaster(list[i]));
}
return _mysqlDao.ExcuteSqls(arrayList);
}
catch (Exception ex)
{
throw new Exception("BonusMasterMgr-->BonusMasterAdd-->" + arrayList.ToString() + ex.Message, ex);
}
}
public int Update(Serial serial)
{
try
{
return _serialDao.Update(serial);
}
catch (Exception ex)
{
throw new Exception("SerialMgr-->Update(Serial serial)-->" + ex.Message, ex);
}
}
public string InsertStr(Serial serial)
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat("insert into serial(serial_value,serial_id)values('{0}','{1}');", serial.Serial_Value, serial.Serial_id);
return strSql.ToString();
}
catch (Exception ex)
{
throw new Exception("SerialDao.InsertStr-->" + ex.Message + strSql.ToString(), ex);
}
}
public int Save(Model.Redirect query)
{
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connectionStr);
StringBuilder sbExSql = new StringBuilder();
SerialDao _serialDao = new SerialDao(connectionStr);
int id = 0;
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
//開啟事物
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
StringBuilder Sql = new StringBuilder();
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 4;
mySqlCmd.CommandText = _serialDao.Update(serial.Serial_id);//獲取鏈接管理在serial裡面的值
sbExSql.Append(mySqlCmd.CommandText);
query.redirect_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
sbExSql.Append(_redirectDao.Save(query));
id = _access.execCommand(_redirectDao.Save(query));
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("RedirectMgr-->Save-->" + ex.Message + sbExSql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
//define('SERIAL_ID_EDM_GROUP', 50); // 電子報流水號
public string SaveEdmGroup(EdmGroup query)
{
string json = string.Empty;
Serial serial = new Serial();
ArrayList arrList = new ArrayList();
try
{
if (query.group_id == 0)//新增
{
serial.Serial_id=50;
serial=_ISerialImpl.GetSerialById(serial.Serial_id);//根據ID得到serial_value;
query.group_id=Convert.ToUInt32(serial.Serial_Value) + 1;//將serial_value值加1就是group_id;
arrList.Add(_edmGroup.InsertEdmGroup(query));//insert edm_group
arrList.Add(_ISerialImpl.Update(serial.Serial_id));//update serial
if (_edmGroup.execSql(arrList))
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
else//編輯
{
if (_edmGroup.UpEdmGroup(query) > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
return json;
}
catch (Exception ex)
{
throw new Exception("EdmGroupMgr-->UpEdmGroup-->" + ex.Message, ex);
}
}
/// <summary>
/// 頁面的第一次保存,向product_category和promotionsAmountFare中新增基本數據并分別獲取category_id和id
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(PromotionsAmountFareQuery model)
{
model.Replace4MySQL();
int id = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
//#region 保存第一步到product_category 獲取prodduct_amount_fare的category_id
ProductCategory pmodel = new ProductCategory();
pmodel.category_name = model.name;
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_father_id = model.category_father_id;
pmodel.category_ipfrom = model.category_ipfrom;
pmodel.category_display = Convert.ToUInt32(model.status);
mySqlCmd.CommandText = _cateDao.SaveCategory(pmodel);
model.category_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(model.category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serial);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//#endregion
PromotionsAmountFare pfmodel = new PromotionsAmountFare();
pfmodel.name = model.name;
pfmodel.event_desc = model.event_desc;
pfmodel.vendor_coverage = model.vendor_coverage;
pfmodel.event_type = model.event_type;
pfmodel.kuser = model.kuser;
pfmodel.created = model.created;
pfmodel.active = model.active;
pfmodel.category_id = model.category_id;
pfmodel.status = model.status;
pfmodel.payment_code = model.payment_code;
mySqlCmd.CommandText = SavePromoFare(pfmodel);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromotionsAmountFareDao-->Save-->" + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
public string OrderWaitClick(OrderMasterStatusQuery query)
{
string json = "";
Serial s = new Serial();//流水號
ArrayList sql = new ArrayList();
OrderMaster om = new OrderMaster();
OrderSlave os = new OrderSlave();
OrderMasterStatusQuery oms = new OrderMasterStatusQuery();
List<OrderSlaveQuery> vendor = new List<OrderSlaveQuery>();
try
{
vendor = _orderSlaveDao.GetVendor(query.order_id);
if (vendor.Count > 0)
{
uint a = 1;
om.Order_Id = query.order_id;
om.Order_Status = query.order_status;
om.Order_Ipfrom = query.status_ipfrom;
//獲取變更order_master.status和付款money的sql
sql.Add(_orderMaterDao.UpdateOrderMasterStatus(om));
s = _serial.GetSerialById(29);//獲取訂單主檔狀態流水號
sql.Add(_serial.Update(29));//變更流水號+1
query.serial_id = s.Serial_Value+a;
//往訂單記錄表插入一條等待付款的狀態數據
sql.Add(_orderMaterStatusDao.Insert(query));
//
foreach (var item in vendor)
{
os.Slave_Id = item.Slave_Id;
os.Slave_Ipfrom = query.status_ipfrom;
sql.Add(_orderSlaveDao.UpdOrderSlaveStatus(os));
//往order_slave_status表插入數據
s = _serial.GetSerialById(31);//獲取slaver狀態表流水號
sql.Add(_serial.Update(31));//變更流水號+1
oms.serial_id = s.Serial_Value + a;
oms.slave_id = item.Slave_Id;
oms.order_status = query.order_status;
oms.status_description = query.status_description;
oms.status_ipfrom = query.status_ipfrom;
sql.Add(_orderMaterStatusDao.InsertSlave(oms));
a++;
}
if (_mySqlDao.ExcuteSqlsThrowException(sql))
{
json = "{success:true}";
}
else
{
json = "{success:true,msg:2}";//執行sql報錯
}
}
else
{
json = "{success:flase,msg:3}";//slave沒有數據
}
return json;
}
catch (Exception ex)
{
throw new Exception("OrderDetailMgr-->OrderWaitClick-->sql:" + sql + ",Message:" + ex.Message, ex);
}
}
public int SaveOne(PromoPair model)
{
int id = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
StringBuilder sb = new StringBuilder();
string father_id = _access.getDataTable("SELECT parameterProperty from t_parametersrc where parameterCode='P1';").Rows[0][0].ToString();
ProductCategory pmodel = new ProductCategory();
pmodel.category_father_id = Convert.ToUInt32(father_id);
pmodel.category_name = model.event_name;
pmodel.category_display = 1;
pmodel.category_show_mode = 0;
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_display = 0;
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
//mySqlCmd.CommandText = string.Format("INSERT INTO product_category(category_father_id,category_name,category_display,category_show_mode,category_createdate) values('{0}','{1}','{2}','{3}','{4}'); select @@identity ;", father_id, model.event_name, "1", "0", CommonFunction.GetPHPTime(model.created.ToString()));
model.category_id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(model.category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serial);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
#region insert red+green
pmodel.category_father_id = Convert.ToUInt32(model.category_id);
pmodel.category_name = "紅";
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
model.cate_red = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serialred = new Serial();
serialred.Serial_id = 12;
serialred.Serial_Value = Convert.ToUInt32(model.cate_red);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serialred);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//mySqlCmd.CommandText = string.Format("INSERT INTO product_category(category_father_id,category_name,category_display,category_show_mode,category_createdate,status) values('{0}','{1}','{2}','{3}','{4}',1); select @@identity ;", model.category_id, "紅", "1", "0", CommonFunction.GetPHPTime(model.created.ToString()));
pmodel.category_name = "綠";
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
model.cate_green = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serialgreen = new Serial();
serialgreen.Serial_id = 12;
serialgreen.Serial_Value = Convert.ToUInt32(model.cate_green);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serialgreen);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//mySqlCmd.CommandText = string.Format("INSERT INTO product_category(category_father_id,category_name,category_display,category_show_mode,category_createdate,status) values('{0}','{1}','{2}','{3}','{4}',1); select @@identity ;", model.category_id, "綠", "1", "0", CommonFunction.GetPHPTime(model.created.ToString()));
#endregion
sb.AppendFormat("INSERT INTO promo_pair(event_name,event_desc,event_type,created,kuser,category_id,active,cate_red,cate_green,vendor_coverage) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'); select @@identity ;", model.event_name, model.event_desc, model.event_type, CommonFunction.DateTimeToString(model.created), model.kuser, model.category_id, "0", model.cate_red, model.cate_green,model.vendor_coverage);
mySqlCmd.CommandText = sb.ToString();
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromoPairDao-->SaveOne-->" + ex.Message, ex);
}
finally
{
mySqlConn.Close();
}
return id;
}
/// <summary>
/// 新增編輯處理
/// </summary>
/// <param name="EGEquery"></param>
/// <param name="EEquery"></param>
/// <returns></returns>
public string EdmGroupEmailEdit(Model.Query.EdmGroupEmailQuery query)
{
query.Replace4MySQL();
string json = string.Empty;
EdmEmail oldQuery = new EdmEmail();
EdmEmail emailQuery = new EdmEmail();
EdmGroupEmailQuery groupemailQuery = new EdmGroupEmailQuery();
List<EdmEmail> store = new List<EdmEmail>();
List<EdmGroupEmailQuery> listEGE=new List<EdmGroupEmailQuery>();
Serial serial = new Serial();
uint email_id=query.email_id;
try
{
emailQuery.email_name = query.email_name;
if (string.IsNullOrEmpty(query.email_name))
{//如果郵件名稱沒有填,則默認郵件地址@符號以前的內容
string[] strs = query.email_address.Split('@');
query.email_name = strs[0].ToString();
emailQuery.email_name = query.email_name;
}
oldQuery.email_address = query.email_address;
emailQuery.email_address = query.email_address;
#region 判斷郵件地址在edm_email表中是否存在
store = _IEdmGroupEmailMgr.getList(oldQuery);//判斷該郵件是否存在
if (store != null && store.Count > 0)//存在,獲取email_id
{
emailQuery.email_id = store[0].email_id;
emailQuery.email_updatedate = Convert.ToInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
if (query.email_name != store[0].email_name)//檔修改的郵件名稱與已存在的不一致就更新成一致
{
if (_IEdmGroupEmailMgr.UpdateEdmEmail(emailQuery) <= 0)
{
json = "{success:true,msg:1,type:0}";//msg=1代表更新郵件時出錯,type=0代表更新郵件名稱時錯誤
return json;
}
groupemailQuery.email_name = query.email_name;
groupemailQuery.email_updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
groupemailQuery.email_id = emailQuery.email_id;
DataTable ids = _IEdmGroupEmailMgr.GetGroupID(emailQuery.email_address);
for (int i = 0; i < ids.Rows.Count; i++)
{
groupemailQuery.group_id = Convert.ToUInt32(ids.Rows[i][0]);
int result = _IEdmGroupEmailMgr.UpdateEGEname(groupemailQuery);
if (result > 0)
{
continue;
}
else
{
json = "{success:true,msg:1,type:0}";
return json;
}
}
}
}
else
{ //不存在,在edm_email表新增
//uint largestID=0;
//string empty = string.Empty;
//uint id = 0;
// _edmemailDao.GetData(empty, out largestID, out id, out empty);
string sql = _serialDao.Update(51);//51代表edm_email表
serial = _IEdmGroupEmailMgr.execSql(sql);
emailQuery.email_id = Convert.ToUInt32(serial.Serial_Value);//largestID + 1;
emailQuery.email_createdate = Convert.ToInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
emailQuery.email_updatedate = Convert.ToInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
emailQuery.email_check = 0;
_IEdmGroupEmailMgr.insertEdmEmail(emailQuery);
}
#endregion
query.email_id = emailQuery.email_id;
listEGE = _IEdmGroupEmailMgr.Check(query);
#region 編輯
if (email_id > 0 || (listEGE != null && listEGE.Count > 0))//編輯
{
if (listEGE == null || listEGE.Count <= 0)//檔填寫的郵件地址對應的email_id在edm_group_email表中沒有對應的數據時,新增一條數據
{
query.email_createdate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
query.email_updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
_IEdmGroupEmailMgr.insertEGEInfo(query);
}
query.email_updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
if (email_id != 0 && email_id != query.email_id)//檔編輯時修改的郵件地址不是原來的郵件地址時,把原來的edm_group_email表中的數據刪除
{
EdmGroupEmailQuery egequery = new EdmGroupEmailQuery();
egequery.group_id = query.group_id;
egequery.email_ids = email_id.ToString();
_IEdmGroupEmailMgr.DeleteEdmGroupEmail(egequery);
}
int res = _IEdmGroupEmailMgr.UpdateEGE(query);//更新edm_group_email表數據
if (res > 0)
{
json = "{success:true,msg:0,type:1}";//0表示成功,type=1代表編輯
}
else
{
json = "{success:true,msg:3,type:1}";//0表示更新失敗,type=1代表編輯
return json;
}
}
#endregion
#region 新增
else
{ //新增
query.email_createdate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
query.email_updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
int res = _IEdmGroupEmailMgr.insertEGEInfo(query);//新增edm_group_email表數據
if (res > 0)
{
json = "{success:true,msg:0,type:2}";//0表示成功,type=2代表新增操作
}
else
{
json = "{success:true,msg:2,type:2}";//msg=2表示新增時出錯了,type=2代表新增操作
return json;
}
}
#endregion
#region 更新edm_group表的群組人數
int num = UpdateCount(Convert.ToInt32(query.group_id));
if (num <= 0)
{
json = "{success:false}";
}
#endregion
return json;
}
catch (Exception ex)
{
throw new Exception("EdmGroupEmailMgr-->EdmGroupEmailEdit" + ex.Message, ex);
}
}
//新添加
#region 新增數據 第一步試吃/紅利抵用保存
#region 事物新增主表數據和product_category表數據 + int Save(PromotionsAmountGiftQuery query)
public int TryEatAndDiscountSave(PromotionsAmountGiftQuery query)
{
_proCateDao = new ProductCategoryDao(connStr);
query.Replace4MySQL();
int id = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
StringBuilder sbExSql = new StringBuilder();
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
//#region 保存第一步到product_category 獲取prodduct_amount_fare的category_id
ProductCategory pmodel = new ProductCategory();
pmodel.category_name = query.name;
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_father_id = query.category_father_id;
pmodel.category_ipfrom = query.category_ipfrom;
pmodel.category_display = Convert.ToUInt32(query.status);
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
sbExSql.Append(mySqlCmd.CommandText);
query.category_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(query.category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serial);
sbExSql.Append(mySqlCmd.CommandText);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//#endregion
PromotionsAmountGift pgmodel = new PromotionsAmountGift();
pgmodel.name = query.name;
pgmodel.event_desc = query.event_desc;
pgmodel.vendor_coverage = query.vendor_coverage;
pgmodel.event_type = query.event_type;
pgmodel.freight_price = query.freight_price;
pgmodel.kuser = query.kuser;
pgmodel.created = query.created;
pgmodel.status = query.status;
pgmodel.category_id = query.category_id;
pgmodel.dividend = query.dividend;
mySqlCmd.CommandText = TryEatAndDiscountSavePromoGift(pgmodel);
sbExSql.Append(mySqlCmd.CommandText);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromotionsAmountGiftDao-->Save-->" + ex.Message + sbExSql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
/// <summary>
/// 用於返回事物所用到的sql語句
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string UpdateAutoIncreament(Serial serial)
{
StringBuilder strSql = new StringBuilder("update serial set ");
strSql.AppendFormat("serial_value={0} where serial_id={1};", serial.Serial_Value, serial.Serial_id);
return strSql.ToString();
}
public string Deduct_User_Bonus(int deduct_bonus, string order_id, string user_id)
{
BonusMasterQuery b = new BonusMasterQuery();
BonusRecord br = new BonusRecord();
Serial s = new Serial();
_serial = new SerialDao(connString);
_bonus = new BonusMasterDao(connString);
List<BonusMaster> store = new List<BonusMaster>();
List<BonusMaster> store2 = new List<BonusMaster>();
System.Net.IPAddress[] ips = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
if (ips.Count() > 0)
{
b.master_ipfrom = ips[0].ToString();
}
StringBuilder sql = new StringBuilder();
StringBuilder sqlstr = new StringBuilder();
try
{
int bonus_num = deduct_bonus;
//是否發放購物金
b.master_note = order_id;
b.master_total = uint.Parse(deduct_bonus.ToString());
b.bonus_type = 1;
store = _bonus.GetBonus(b);
if (store.Count == 1)
{
bool user = false;
foreach (var item in store)
{
if (item.master_total == item.master_balance)
{//判斷發放的購物金是否使用
user = true;
bonus_num = 0;
}
else
{
bonus_num = bonus_num - item.master_balance;
}
b.master_id = item.master_id;
b.masterid = item.master_id.ToString() + ",";
}
s = _serial.GetSerialById(28);
uint a = 1;
#region 發放購物金扣除
if (deduct_bonus - bonus_num > 0)
{
//先清除bonus_master表裏面的發放的購物金
b.master_balance = deduct_bonus - bonus_num;
b.master_writer = "訂單取消";
sqlstr.Append(_bonus.UpBonusMaster(b));
//并記錄到購物金記錄表中
sqlstr.Append(_serial.Update(28));
br.record_id = uint.Parse(s.Serial_Value.ToString()) + a;
a++;
br.master_id = b.master_id;
br.type_id = 32;
br.order_id = uint.Parse(b.master_note);
br.record_use = uint.Parse(b.master_balance.ToString());
br.record_note = order_id;
br.record_writer = "訂單整筆取消";
br.record_ipfrom = b.master_ipfrom;
sqlstr.Append(_bonus.InsertBonusRecord(br));
}
if (!user)
{//發放購物金被使用
b.user_id = uint.Parse(user_id.ToString());
b.masterid = b.masterid.TrimEnd(',');
uint order = uint.Parse(b.master_note.ToString());
b.master_note = null;
b.master_total = 0;
b.usebonus = "K";
//該用戶剩餘可用購物金
store2 = _bonus.GetBonus(b);
foreach (var item in store2)
{
if (bonus_num > item.master_balance)
{
b.master_balance = item.master_balance;
bonus_num = bonus_num - item.master_balance;
}
else
{
b.master_balance = bonus_num;
bonus_num = 0;
}
//變更bonus_master表裏面的發放的購物金
b.master_id = item.master_id;
sqlstr.Append(_bonus.UpBonusMaster(b));
//記錄到購物金記錄表中
sqlstr.Append(_serial.Update(28));
br.record_id = uint.Parse(s.Serial_Value.ToString()) + a;
a++;
br.master_id = b.master_id;
br.type_id = 32;
br.order_id = order;
br.record_use = uint.Parse(b.master_balance.ToString());
br.record_note = order_id;
br.record_writer = "訂單取消被使用,額外扣除購物金";
br.record_ipfrom = b.master_ipfrom;
sqlstr.Append(_bonus.InsertBonusRecord(br));
if (bonus_num == 0)
{
break;
}
}
}
if (bonus_num > 0)
{//該用戶剩餘的購物金不夠扣剩下記錄到表中
sqlstr.AppendFormat(@"insert into users_deduct_bonus (deduct_bonus,user_id,createdate,order_id)");
sqlstr.AppendFormat(@" values('{0}','{1}','{2}','{3}');", bonus_num, user_id, CommonFunction.GetPHPTime(DateTime.Now.ToString()), order_id);
}
#endregion
}
return sqlstr.ToString();
}
catch (Exception ex)
{
throw new Exception("OrderReturnlMasterDao-->Deduct_User_Bonus-->" + ex.Message, ex);
}
}
// [HttpPost]
public HttpResponseBase SaveVipUserGroup()
{
NameValueCollection param = Request.Params;
VipUserGroup userGroup = new VipUserGroup();
string json = string.Empty;
bool size = true;
Serial serial = new Serial();
_userGroupMgr = new VipUserGroupMgr(mySqlConnectionString);
_ISerImplMgr = new SerialMgr(mySqlConnectionString);
serial = _ISerImplMgr.GetSerialById(72);
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
string NewName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
string NewFileName = string.Empty;
FileManagement fileLoad = new FileManagement();
try
{
#region 新增
if (String.IsNullOrEmpty(param["group_id"]))
{
if (!string.IsNullOrEmpty(Request.Form["group_name"]))
{
userGroup.group_name = Request.Form["group_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["tax_id"]))
{
userGroup.tax_id = Request.Form["tax_id"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["eng_name"]))
{
userGroup.eng_name = Request.Form["eng_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["gift_bonus"]))
{
userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]);
}
if (!string.IsNullOrEmpty(Request.Form["group_category"]))
{
userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]);
}
siteConfigMgr = new SiteConfigMgr(Server.MapPath(xmlPath));
try
{
if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0)
{
HttpPostedFileBase file = Request.Files["image_name"];
if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024)
{
NewName = Path.GetFileName(file.FileName);
bool result = false;
//獲得文件的後綴名
fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower();
//新的文件名是隨機數字
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention;
NewName = NewFileName;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
string[] mapPath = new string[1];
mapPath[0] = promoPath.Substring(1, promoPath.Length - 2);
string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1);
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath);
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)
{
userGroup.image_name = NewName;
}
}
else
{
size = false;
}
}
}
catch (Exception)
{
userGroup.image_name = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["check_iden"]))
{
userGroup.check_iden = int.Parse(Request.Params["check_iden"]);
}
userGroup.createdate = (uint)CommonFunction.GetPHPTime(DateTime.Now.ToString());
userGroup.group_id = uint.Parse((serial.Serial_Value + 1).ToString());
if (_userGroupMgr.Insert(userGroup) > 0)
{
serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/
_ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/
if (size)
{
json = "{success:true,msg:\"" + "" + "\"}";
}
else
{
json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB！" + "\"}";
}
}
else
{
json = "{success:false,msg:\"" + "新增失敗!" + "\"}";
}
}
#endregion
#region 編輯
else
{
_userGroupMgr = new VipUserGroupMgr(mySqlConnectionString);
userGroup.group_id = Convert.ToUInt32(param["group_id"]);
VipUserGroup oldUserGroup = _userGroupMgr.GetModelById(userGroup.group_id);
if (!string.IsNullOrEmpty(Request.Form["group_name"]))
{
userGroup.group_name = Request.Form["group_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["tax_id"]))
{
userGroup.tax_id = Request.Form["tax_id"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["eng_name"]))
{
userGroup.eng_name = Request.Form["eng_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Form["gift_bonus"]))
{
userGroup.gift_bonus = Convert.ToUInt32(Request.Form["gift_bonus"]);
}
if (!string.IsNullOrEmpty(Request.Form["group_category"]))
{
userGroup.group_category = Convert.ToUInt32(Request.Form["group_category"]);
}
try
{
//如果圖片沒有改變
if (Request.Form["image_name"] == oldUserGroup.image_name)
{
userGroup.image_name = Request.Form["image_name"];
}
else
{
//圖片改變了
if (Request.Files["image_name"] != null && Request.Files["image_name"].ContentLength > 0)
{
HttpPostedFileBase file = Request.Files["image_name"];
if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024)
{
NewName = Path.GetFileName(file.FileName);
bool result = false;
//獲得文件的後綴名
fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower();
//新的文件名是隨機數字
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
NewFileName = hash.Md5Encrypt(newRand.ToString(), "32") + fileExtention;
NewName = NewFileName;
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
string[] mapPath = new string[1];
mapPath[0] = promoPath.Substring(1, promoPath.Length - 2);
string jian = localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1);
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), mapPath);
// returnName += promoPath + NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
string oldFileName = oldUserGroup.image_name;
//FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
//List<string> tem = ftp.GetFileList();
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)
{
userGroup.image_name = NewName;
if (System.IO.File.Exists(ServerPath + oldFileName))
{
FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd);
if (System.IO.File.Exists(localPromoPath + oldFileName))
{
ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片
}
DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
}
}
else
{
userGroup.image_name = oldUserGroup.image_name;
}
}
else
{
size = false;
userGroup.image_name = oldUserGroup.image_name;
}
}
}
}
catch (Exception)
{
userGroup.image_name = oldUserGroup.image_name;
}
try
{
userGroup.check_iden = int.Parse(Request.Params["check_iden"]);
}
catch (Exception)
{
userGroup.check_iden = 0;
}
if (_userGroupMgr.Update(userGroup) > 0)
{
if (size)
{
json = "{success:true,msg:\"" + "" + "\"}";
}
else
{
json = "{success:true,msg:\"" + " 文件大小應大於1KB小於100KB！" + "\"}";
}
}
else
{
json = "{success:false,msg:\"" + "修改失敗!" + "\"}";
}
}
#endregion
}
catch (Exception ex)
{
json = "{success:false,msg:\"" + "異常" + "\"}";
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int AnnounceSave(AnnounceQuery store)
{
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
StringBuilder sql = new StringBuilder();
int re = 0;
store.Replace4MySQL();
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
SerialDao _serialDao = new SerialDao(connStr);
#region 新增
if (store.announce_id == 0)//新增
{
Serial sQuery = new Serial();
store.announce_id = Convert.ToUInt32(_serialDao.GetSerialById(65).Serial_Value + 1); // GetSerialValue(20);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(new Serial { Serial_id = 65, Serial_Value = store.announce_id });
mySqlCmd.CommandText += InsertAnnounce(store);
re = mySqlCmd.ExecuteNonQuery();
}
else//編輯
{
mySqlCmd.CommandText = UpdateAnnounce(store);
re = mySqlCmd.ExecuteNonQuery();
}
#endregion
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("AnnounceDao-->AnnounceSave-->" + mySqlCmd.ToString() + ex.Message, ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return re;
}
public string Import(DataTable _dt, EdmGroupEmailQuery groupMailQuery)
{
string json = "{success:'true'}";
ArrayList arrList = new ArrayList();
Serial serial = new Serial();
EdmEmailQuery emailQuery = new EdmEmailQuery();
EdmGroupQuery query = new EdmGroupQuery();
List<EdmEmail> emailStore = new List<EdmEmail>();
List<EdmGroupEmailQuery> groupMailStore = new List<EdmGroupEmailQuery>();
string regex = @"^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$";
try
{
query.group_id = groupMailQuery.group_id;
for (int i = 0; i < _dt.Rows.Count; i++)
{
if (_dt.Rows[i][0] != "")
{
if( Regex.IsMatch(_dt.Rows[i][0].ToString(), regex))
{
emailQuery.email_address = _dt.Rows[i][0].ToString();
//若不為 0、1、未指定或有錯誤時，預設皆為訂閱。
#region 有2列
int n = 1;
if (_dt.Columns.Count >= 2)
{
if (_dt.Rows[i][1] != "")
{
#region MyRegion
if (int.TryParse(_dt.Rows[i][1].ToString(), out n))
{
groupMailQuery.email_status = Convert.ToUInt32(_dt.Rows[i][1].ToString());
if (groupMailQuery.email_status != 1 && groupMailQuery.email_status != 0)
{
groupMailQuery.email_status = 1;
}
}
else
{
groupMailQuery.email_status = 1;
}
#endregion
}
else
{
groupMailQuery.email_status = 1;
}
}
else
{
groupMailQuery.email_status = 1;
}
#endregion
#region 有3列
if (_dt.Columns.Count == 3)
{
if (_dt.Rows[i][2] == "")//或無指定，預設以電子信箱帳號代替。
{
emailQuery.email_name = _dt.Rows[i][0].ToString().Substring(0, _dt.Rows[i][0].ToString().LastIndexOf("@"));
}
else
{
emailQuery.email_name = _dt.Rows[i][2].ToString();
}
}
else
{
emailQuery.email_name = _dt.Rows[i][0].ToString().Substring(0, _dt.Rows[i][0].ToString().LastIndexOf("@"));
}
#endregion
groupMailQuery.email_name = emailQuery.email_name;
//查看edm_mail中郵箱是否存在，如果重複則更新
emailStore = _IEdmGroupEmailMgr.getList(emailQuery);
#region 存在,更新
if (emailStore.Count > 0)//存在,更新
{
emailQuery.email_id = emailStore[0].email_id;
emailQuery.email_updatedate = Convert.ToInt32(CommonFunction.GetPHPTime());
arrList.Add(_IEdmGroupEmailMgr.UpdateEdmEmailStr(emailQuery));//更新edm_mail表
groupMailQuery.email_id = emailQuery.email_id;
// 查看 edm_group_email表中數據是否存在
if (_IEdmGroupEmailMgr.Check(groupMailQuery).Count > 0)//存在
{
groupMailQuery.email_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime());
arrList.Add(_edmGroup.UpdateEGE(groupMailQuery));
}
else
{
groupMailQuery.email_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime());
groupMailQuery.email_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime());
arrList.Add(_edmGroup.insertEGEInfo(groupMailQuery));
}
}
#endregion
#region 不存在新增
else//不存在新增
{
//1 新增edm_email表
//2 新增edm_group_email表
string sql = _ISerialImpl.Update(51);//51代表edm_email表
serial = _IEdmGroupEmailMgr.execSql(sql);
emailQuery.email_id = Convert.ToUInt32(serial.Serial_Value);
emailQuery.email_createdate = Convert.ToInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
emailQuery.email_updatedate = Convert.ToInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
emailQuery.email_check = 0;
arrList.Add(_edmGroup.insertEdmEmail(emailQuery));
groupMailQuery.email_createdate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
groupMailQuery.email_updatedate = Convert.ToUInt32(Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
groupMailQuery.email_id = emailQuery.email_id;
arrList.Add(_edmGroup.insertEGEInfo(groupMailQuery));
}
#endregion
}
}
}
if (arrList.Count > 0)
{
if (_mysql.ExcuteSqlsThrowException(arrList))
{
json = "{success:'true'}";
}
else
{
json = "{success:'false'}";
}
}
DataTable _dtCount = _IEdmGroupEmailMgr.getCount(Convert.ToInt32(query.group_id));
if (_dtCount.Rows.Count > 0)
{
query.group_total_email = Convert.ToUInt32(_dtCount.Rows[0][0]);
_IEdmGroupEmailMgr.updateEdmGroupCount(query);
}
return json;
}
catch (Exception ex)
{
throw new Exception("EdmGroupMgr-->Import-->" + ex.Message, ex);
}
}
public string ChangeDeliverData(OrderShowMasterQuery oms, OrderShowMasterQuery newOms, OrderMasterQuery om)
{
string json = string.Empty;
ArrayList arrList = new ArrayList();
Serial serial = new Serial();
oms.status_description = "Writer:" + "(" + om.user_id + ")" + om.user_name + "," + "\r\n" + "異動收貨資訊";
oms.status_ipfrom = om.Order_Ipfrom;
oms.StatusCreateDate = DateTime.Now;
oms.order_id = om.Order_Id;
om.mdd = true;
newOms = _orderMasterDao.GetData(om.Order_Id);
string note_order = newOms.note_order;
if (note_order == "")
{
om.note_order = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "更改收件人資訊";
}
else
{
om.note_order = note_order + '/' + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "更改收件人資訊";
}
oms.order_status = newOms.order_status;
arrList.Add(_orderMasterDao.UpOrderMaster(om));//更新order_master
arrList.Add(_orderMasterDao.UpdateDM(om));//更新deliver_master
serial = _serialDao.GetSerialById(29);
oms.serial_id = Convert.ToInt32(serial.Serial_Value) + 1;
serial.Serial_Value = Convert.ToUInt64(oms.serial_id);
arrList.Add(_serialDao.UpdateAutoIncreament(serial));//更新serial表
arrList.Add(_orderMasterDao.InsertOrderMasterStatus(oms));//插入order_master_status表
if (_mysqlDao.ExcuteSqlsThrowException(arrList))
{
json = "{success:true}";
#region 發送郵件
MailHelper mail = new MailHelper();
string body = "付款單號 : " + om.Order_Id + " 已更改收貨人資訊，請重新檢視出貨單<br/>更改時間：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "<br/><br/>以上為系統通知信請勿直接回覆，謝謝！ ";
mail.SendMailAction("*****@*****.**", "收貨人資訊變更", body);
#endregion
}
else
{
json = "{success:false}";
}
return json;
}
public string OrderReturn(OrderReturnMasterQuery query)
{
string josn = "";
List<OrderDetailQuery> orm = new List<OrderDetailQuery>();
List<OrderDetail> od = new List<OrderDetail>();
Serial s = new Serial();//流水號
Serial s1 = new Serial();//流水號
OrderReturnMaster m = new OrderReturnMaster();
StringBuilder sb = new StringBuilder();
ArrayList arrList = new ArrayList();
string r_id="";
uint slave=0;
try
{
orm = _orderReturnMaster.GetOrderreturn(query);
if (orm.Count == 0)
{//1.判斷detail_id選中的個數,沒有則退出; 查詢該訂單詳細數據,取出需要的字段;
return josn = "{success:true,msg:2}";//
}
uint a = 1;
foreach (var item in orm)
{//同一出貨商的商品放在同一陣列中,成立獨立的退貨單
if (slave != item.Slave_Id)
{ // (1)區分出貨商order_slave.slave_id相同的添加到同一個退貨單中.
s =_serial.GetSerialById(45);//獲取退貨流水號
s.Serial_Value=s.Serial_Value+ a;
m.return_id = uint.Parse(s.Serial_Value.ToString());
r_id += m.return_id.ToString() + ",";
m.order_id = item.Order_Id;
m.vendor_id = item.Vendor_Id;
m.return_status = 0;
m.return_note = query.return_note;
m.return_ipfrom = query.return_ipfrom;
//新增退貨單信息
arrList.Add(_orderReturnMaster.InsertOrderReturnMaster(m));
arrList.Add(_serial.Update(45));//流水號+1
slave = item.Slave_Id;
//修改訂單的付款狀態
arrList.Add(_orderReturnMaster.UpdOrderMaster(item.Order_Id, "5"));
//新增訂單狀態變更記錄
s1 = _serial.GetSerialById(29);//獲取訂單主檔狀態流水號
s1.Serial_Value = s1.Serial_Value + a;
arrList.Add(_orderReturnMaster.InsertOrderMasterStatus(s1.Serial_Value, item.Order_Id, "91", "miaoshu"));
arrList.Add(_serial.Update(29));//流水號+1
a++;
}
//變更相關訂單細項商品狀態,并新增退貨單細項.判斷是否是組合商品并修改商品狀態.
arrList.Add(_orderReturnMaster.InsertOrderReturnDetail(s.Serial_Value.ToString(), item.Detail_Id.ToString()));
if (item.item_mode == 1)
{//變更組合商品內所有商品狀態,獲取時候是否獲取到整個組合商品
od = _orderReturnMaster.Getdetail(item.Slave_Id.ToString(), item.Parent_Id.ToString());
foreach (var item1 in od)
{
arrList.Add(_orderReturnMaster.UpdOrderDetail(item1.Detail_Id.ToString()));
}
}
else
{//不是組合商品就只修改該商品的狀態
arrList.Add(_orderReturnMaster.UpdOrderDetail(item.Detail_Id.ToString()));
}
}
//10000以上代表拋轉過資料，需重拋轉
if (_orderReturnMaster.GetExportFlag(m.order_id.ToString())>0)
{
arrList.Add(_orderReturnMaster.UpdExportFlag(m.order_id.ToString()));
}
r_id = r_id.Substring(0, r_id.Length - 1);
//執行sql語句
if ( _mySqlDao.ExcuteSqlsThrowException(arrList))
{
josn = "{success:true,msg:0,return_id:'"+r_id+"'}";
}
else
{
josn = "{success:true,msg:1}";
}
return josn;
}
catch (Exception ex)
{
throw new Exception("OrderReturnMasterMgr.OrderReturn-->" + ex.Message, ex);
}
}
public HttpResponseBase SaveRedirect()
{
string json = string.Empty;
try
{
Redirect redirect = new Redirect();
_redirectMgr = new RedirectMgr(mySqlConnectionString);
_serialMgr = new SerialMgr(mySqlConnectionString);
redirect.redirect_name = Request.Params["redirect_name"].ToString();
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
redirect.group_id = uint.Parse(Request.Params["group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["user_group_id"]))
{
redirect.user_group_id = int.Parse(Request.Params["user_group_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["redirect_status"]))
{
redirect.redirect_status = uint.Parse(Request.Params["redirect_status"]);
}
redirect.redirect_url = Request.Params["redirect_url"];
redirect.redirect_note = Request.Params["redirect_note"];
redirect.redirect_ipfrom = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (!string.IsNullOrEmpty(Request.Params["redirect_id"]))
{
redirect.redirect_id = uint.Parse(Request.Params["redirect_id"]);
redirect.redirect_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime());
if (_redirectMgr.Update(redirect) > 0)
{
json = "{success:true}";
}
}
else
{
redirect.redirect_id = uint.Parse((_serialMgr.GetSerialById(4).Serial_Value + 1).ToString());
redirect.redirect_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime());
redirect.redirect_updatedate = redirect.redirect_createdate;
if (_redirectMgr.Save(redirect) > 0)
{
Serial serial = new Serial();
serial.Serial_id = 4;
serial.Serial_Value = redirect.redirect_id;
_serialMgr.Update(serial);
json = "{success:true}";
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public int SaveUserPhone(Model.Query.UserQuery uQuery)
{
_userhistoryDao = new UserHistoryDao(connStr);
_smsdao = new SmsDao(connStr);
_serialDao = new SerialDao(connStr);
Serial serial = new Serial();
uQuery.Replace4MySQL();
int i = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
#region 處理serial表數據
mySqlCmd.CommandText = _serialDao.Update(22);//22電話會員
serial = _serialDao.GetSerialById(22);
uQuery.user_id = Convert.ToUInt32(serial.Serial_Value) + 1;
#endregion
#region 處理user 和user_history數據
mySqlCmd.CommandText = Save(uQuery);
mySqlCmd.CommandText += _userhistoryDao.Save(uQuery);
#endregion
#region 處理sms表
Sms smsModel = new Sms();
smsModel.type = 9;
smsModel.mobile = uQuery.user_mobile;
smsModel.subject = "電話會員";
smsModel.content = "感謝您選擇成為吉甲地市集電話會員，未來我們將透過簡訊提供商品優惠。日後若有電話訂購服務之需求，可撥打專線(02)2783-4995，謝謝。";
smsModel.send = uQuery.send_sms_ad == true ? 1 : 0;
smsModel.created = uQuery.created;
smsModel.modified = uQuery.created;
smsModel.estimated_send_time = uQuery.created;
mySqlCmd.CommandText += _smsdao.SaveSms(smsModel);
#endregion
i += mySqlCmd.ExecuteNonQuery();
//全部执行成功以后，对serial表的serial_value的值進行變更
if (i == 3)
{
serial.Serial_Value = serial.Serial_Value + 1;
int j = _serialDao.Update(serial);
}
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("UsersDao-->Save-->" + ex.Message + mySqlCmd.CommandText.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return i;
}
//excel
public HttpResponseBase RedirectUploadExcel()
{
string newName = string.Empty;
string json = string.Empty;
_redirectMgr = new RedirectMgr(mySqlConnectionString);
try
{
DTExcels.Clear();
DTExcels.Columns.Clear();
DTExcels.Columns.Add("連結名稱", typeof(String));
DTExcels.Columns.Add("目的連結", typeof(String));
DTExcels.Columns.Add("連結狀態", typeof(String));//1表示正常2表示停用 其他都為正常
int count = 0;//總匯入數
int errorcount = 0;//數據異常個數
int create_user = (Session["caller"] as Caller).user_id;
if (Request.Files["ImportExcelFile"] != null && Request.Files["ImportExcelFile"].ContentLength > 0)
{
HttpPostedFileBase excelFile = Request.Files["ImportExcelFile"];
newName = Server.MapPath(excelPath) + excelFile.FileName;
excelFile.SaveAs(newName);
DataTable dt = new DataTable();
NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newName);
dt = helper.SheetData();
if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0][0].ToString()) && !string.IsNullOrEmpty(dt.Rows[0][1].ToString()))
{
foreach (DataRow dr in dt.Rows)
{
if (!string.IsNullOrEmpty(dr[0].ToString()) && !string.IsNullOrEmpty(dr[1].ToString()))
{
#region 匯入數據
RedirectQuery rd = new RedirectQuery();
rd.group_id = Convert.ToUInt32(Request.Params["group_id"]);//得到群組
try
{
int linkstatus = 0;
if (!int.TryParse(dr[2].ToString(), out linkstatus))
{
linkstatus = 1;
}
if (linkstatus == 2)
{
linkstatus = 2;
rd.redirect_name = dr[0].ToString();//連接名稱
rd.redirect_url = dr[1].ToString();//目的連接
rd.redirect_status = Convert.ToUInt32(linkstatus);//連接狀態
}
else
{
linkstatus = 1;
rd.redirect_name = dr[0].ToString();
rd.redirect_url = dr[1].ToString();
rd.redirect_status = Convert.ToUInt32(linkstatus);
}
rd.redirect_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
rd.redirect_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
rd.redirect_ipfrom = CommonFunction.GetClientIP();
//獲取Serial裡面的redirect_id
_serialMgr = new SerialMgr(mySqlConnectionString);
rd.redirect_id = uint.Parse((_serialMgr.GetSerialById(4).Serial_Value + 1).ToString());
}
catch (Exception ex)
{//不是正常數據時候直接帶1(正常)
int linkstatus = 1;
rd.redirect_name = dr[0].ToString();
rd.redirect_url = dr[1].ToString();
rd.redirect_status = Convert.ToUInt32(linkstatus);
}
int result = 0;//如果獲取到的連結名稱和url為空就不新增
if (!string.IsNullOrEmpty(rd.redirect_name) && !string.IsNullOrEmpty(rd.redirect_url))//&& Regex.IsMatch(rd.redirect_url,'')
{
result = _redirectMgr.EnterInotRedirect(rd);
}
if (result > 0)
{//插入成功一條并修改serial表數據
count++;
Serial serial = new Serial();
serial.Serial_id = 4;
serial.Serial_Value = rd.redirect_id;
_serialMgr.Update(serial);
}
else
{
DataRow drs = DTExcels.NewRow();
drs[0] = dr[0].ToString();
drs[1] = dr[1].ToString();
drs[2] = dr[2].ToString();
DTExcels.Rows.Add(drs);
errorcount++;//插入失敗一條
}
#endregion
}
json = "{success:true,count:" + count + ",errorcount:" + errorcount + "}";
}
}
else
{
json = "{success:true,total:" + 0 + ",error:" + 0 + ",entercount:" + 0 + "}";
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:" + "" + "}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase SavePromotionsAmountDiscount()
{
string jsonStr = String.Empty;
try
{
PromotionsAmountDiscount model = new PromotionsAmountDiscount();
if (!string.IsNullOrEmpty(Request.Params["name"].ToString()))
{
model.name = Request.Params["name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["desc"].ToString()))
{
model.event_desc = Request.Params["desc"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["e_type"].ToString()))
{
model.event_type = Request.Params["e_type"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["devicename"].ToString()))
{
model.device = Convert.ToInt32(Request.Params["devicename"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["start_date"].ToString()))
{
model.start = Convert.ToDateTime(Request.Params["start_date"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["end_date"].ToString()))
{
model.end = Convert.ToDateTime(Request.Params["end_date"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"].ToString()))
{
model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["site"].ToString()))//修改時傳的值為siteName
{
string site = Request.Params["site"].ToString();
Regex reg = new Regex("^([0-9]+,)*[0-9]+$");
if (reg.IsMatch(site))
{
model.site = site;// 將站台改為多選 edit by shuangshuang0420j 20140925 10:08
}
else
{
model.site = site.TrimEnd(',');
}
}
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.muser = model.kuser;
model.modified = model.created;
model.active = false;//不啟用
model.status = 0;
#region 保存第一步到product_category 獲取prodduct_amount_discount的category_id
ProductCategory pmodel = new ProductCategory();
pmodel.category_name = model.name;
//獲取category_father_id
List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", Used = 1, ParameterCode = model.event_type });
if (fatherIdResult.Count != 0)
{
pmodel.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty);
}
else
{
pmodel.category_father_id = 0;
}
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_updatedate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_ipfrom = CommonFunction.GetIP4Address(Request.UserHostAddress.ToString());// Request.UserHostAddress;
pmodel.category_display = Convert.ToUInt32(model.status);
model.category_id = Convert.ToUInt32(_produCateMgr.Save(pmodel));
#endregion
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(model.category_id);
if (_seriMgr.Update(serial) > 0)
{
System.Data.DataTable query = _promoAmountDiscountMgr.Save(model);
if (query != null)
{
jsonStr = "{success:true,id:" + query.Rows[0]["id"] + ",cateID:" + query.Rows[0]["category_id"] + "}";
}
}
else
{
jsonStr = "{success:false }";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public int Update(Serial serial)
{
StringBuilder strSql = new StringBuilder("update serial set ");
strSql.AppendFormat("serial_value={0} where serial_id={1} ;", serial.Serial_Value, serial.Serial_id);
return _dbAccess.execCommand(strSql.ToString());
}
//public List<PromoAdditionalPriceQuery> QueryAll(PromoAdditionalPriceQuery query, out int totalCount)
//{//促銷商品類別和銀行沒有加!
// StringBuilder str = new StringBuilder();
// StringBuilder strall = new StringBuilder();
// StringBuilder strcounts = new StringBuilder();
// try
// {
// strcounts.AppendFormat("select count(PA.id) as totalcounts from promo_additional_price as PA ");
// strall.AppendFormat("SELECT CONCAT(PA.event_type ,right(CONCAT('00000000',PA.id),6)) as 'event_id',PA.id,PA.deliver_type,PA.website,PA.device,event_name,event_desc,PC.banner_image,PC.category_link_url,VUG.group_name,fixed_price,buy_limit,TP.parameterName as deliver_name,TP1.parameterName as device_name,`start` as starts,`end`,active,PA.condition_id,PA.category_id,PA.discount,PA.left_category_id,PA.right_category_id,PA.url_by from promo_additional_price AS PA ");
// str.AppendFormat(" left join vip_user_group as VUG on PA.group_id=VUG.group_id ");
// str.AppendFormat(" LEFT JOIN product_category as PC ON PA.category_id=PC.category_id ");
// str.AppendFormat(" LEFT JOIN t_parametersrc as TP on PA.deliver_type = TP.parameterCode AND TP.parameterType='product_freight'");
// str.AppendFormat(" left join t_parametersrc as TP1 on PA.device = TP1.parameterCode AND TP1.parameterType='device'");
// str.AppendFormat(" left join (select * from t_parametersrc where parameterType='event_type' ) ET ON PA.event_type = ET.parameterCode");
// str.AppendFormat(" where PA.status=1 and PA.event_type= '{0}'", query.event_type);
// totalCount = 0;
// if (query.expired == 1)//是未過期
// {
// str.AppendFormat(" and end >= '{0}'", CommonFunction.DateTimeToString(DateTime.Now));
// }
// else if (query.expired == 0)
// {
// str.AppendFormat(" and end < '{0}'", CommonFunction.DateTimeToString(DateTime.Now));
// }
// totalCount = 0;
// if (query.IsPage)
// {
// System.Data.DataTable _dt = _access.getDataTable(strcounts.ToString() + str.ToString());
// if (_dt != null && _dt.Rows.Count > 0)
// {
// totalCount = Convert.ToInt32(_dt.Rows[0]["totalcounts"]);
// }
// str.AppendFormat("order by PA.id DESC limit {0},{1} ", query.Start, query.Limit);
// }
// return _access.getDataTableForObj<PromoAdditionalPriceQuery>(strall.ToString() + str.ToString());
// }
// catch (Exception ex)
// {
// throw new Exception("PromoAdditionalPriceDao-->QueryAll-->" + ex.Message + strall.ToString() + str.ToString(), ex);
// }
//}
#endregion
#region 不同商品固定價 同品加固定價 不同品加不同價格 新增第一步 +int InsertFirst(PromoAdditionalPrice model)
public int InsertFirst(PromoAdditionalPrice model)
{
model.Replace4MySQL();
int id = 0;
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
string mysql = string.Empty;
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
string father_id = _access.getDataTable(string.Format("SELECT parameterProperty from t_parametersrc where parameterCode='{0}'", model.event_type)).Rows[0][0].ToString();
//insert ProductCategory 獲取category_id
ProductCategory pmodel = new ProductCategory();
pmodel.category_father_id = Convert.ToUInt32(father_id);
pmodel.category_name = model.event_name;
pmodel.category_createdate = (uint)BLL.gigade.Common.CommonFunction.GetPHPTime();
pmodel.category_display = 0;
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
model.category_id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mysql = mySqlCmd.CommandText;
//修改表serial
Serial serial = new Serial();
serial.Serial_id = 12;
serial.Serial_Value = Convert.ToUInt32(model.category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serial);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
if (model.event_type != "A1")
{
pmodel.category_father_id = Convert.ToUInt32(model.category_id);
pmodel.category_name = "左邊";
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
model.left_category_id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serialred = new Serial();
serialred.Serial_id = 12;
serialred.Serial_Value = Convert.ToUInt32(model.left_category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serialred);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//mySqlCmd.CommandText = string.Format("INSERT INTO product_category(category_father_id,category_name,category_display,category_show_mode,category_createdate,status) values('{0}','{1}','{2}','{3}','{4}',1); select @@identity ;", model.category_id, "紅", "1", "0", CommonFunction.GetPHPTime(model.created.ToString()));
pmodel.category_name = "右邊";
mySqlCmd.CommandText = _proCateDao.SaveCategory(pmodel);
model.right_category_id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
//修改表serial
Serial serialgreen = new Serial();
serialgreen.Serial_id = 12;
serialgreen.Serial_Value = Convert.ToUInt32(model.right_category_id);
mySqlCmd.CommandText = _serialDao.UpdateAutoIncreament(serialgreen);
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
PromoAdditionalPrice papModel = new PromoAdditionalPrice();
papModel.event_name = model.event_name;
papModel.event_desc = model.event_desc;
papModel.event_type = model.event_type;
papModel.kuser = model.kuser;
papModel.created = Convert.ToDateTime(CommonFunction.DateTimeToString(model.created));
papModel.active = model.active;
papModel.category_id = model.category_id;
papModel.status = 0;
papModel.left_category_id = model.left_category_id;
papModel.right_category_id = model.right_category_id;
mySqlCmd.CommandText = SavePromoAdditionalPrice(papModel);
mysql = mysql + mySqlCmd.CommandText;
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
else
{
//insert PromoAdditionalPrice 主表 狀態為0
PromoAdditionalPrice papModel = new PromoAdditionalPrice();
papModel.event_name = model.event_name;
papModel.event_desc = model.event_desc;
papModel.event_type = model.event_type;
papModel.kuser = model.kuser;
papModel.created = Convert.ToDateTime(CommonFunction.DateTimeToString(model.created));
papModel.active = model.active;
papModel.category_id = model.category_id;
papModel.status = 0;
mySqlCmd.CommandText = SavePromoAdditionalPrice(papModel);
mysql = mysql + mySqlCmd.CommandText;
id = Convert.ToInt32(mySqlCmd.ExecuteScalar());
mySqlCmd.Transaction.Commit();
}
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("PromoAdditionalPriceDao-->InsertFirst-->" + ex.Message + mysql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return id;
}
public HttpResponseBase BannerImageEdit()
{
string json = string.Empty;
BannerContent bc = new BannerContent();
Serial serial = new Serial();
_bcMgr = new BannerContentMgr(mySqlConnectionString);
_ISerImplMgr = new SerialMgr(mySqlConnectionString);
serial = _ISerImplMgr.GetSerialById(72);
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MinValue");
SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value;
string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value;
string localPromoPath = imgLocalServerPath + promoPath;//圖片存儲地址 /aimg.gigade100.com/ +/promotion/dev/
string NewName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
string NewFileName = string.Empty;
FileManagement fileLoad = new FileManagement();
try
{
string oldImg = string.Empty;
serial = _ISerImplMgr.GetSerialById(6);
List<BannerContent> store = new List<BannerContent>();
if (!string.IsNullOrEmpty(Request.Params["banner_content_id"]))
{
int totalCount = 0;
bc.IsPage = false;
bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]);
if (Request.Params["history"] == "1")
{
bc.banner_status = 3;
}
store = _bcMgr.GetList(bc, out totalCount);
foreach (var item in store)
{
oldImg = item.banner_image;
}
}
bc = new BannerContent();
bc.banner_title = Request.Params["banner_title"];
bc.banner_link_url = Request.Params["banner_link_url"];
if (!string.IsNullOrEmpty(Request.Params["banner_site_id"]))
{
bc.banner_site_id = uint.Parse(Request.Params["banner_site_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"]))
{
bc.banner_link_mode = int.Parse(Request.Params["banner_link_mode"]);
}
if (!string.IsNullOrEmpty(Request.Params["banner_sort"]))
{
bc.banner_sort = uint.Parse(Request.Params["banner_sort"]);
}
if (!string.IsNullOrEmpty(Request.Params["banner_statuses"]))
{
bc.banner_status = uint.Parse(Request.Params["banner_statuses"]);
}
if (!string.IsNullOrEmpty(Request.Params["banner_start"]))
{
bc.banner_start = DateTime.Parse(DateTime.Parse(Request.Params["banner_start"]).ToString("yyyy-MM-dd") + " 00:00:00");
}
if (!string.IsNullOrEmpty(Request.Params["banner_end"]))
{
bc.banner_end = DateTime.Parse(DateTime.Parse(Request.Params["banner_end"]).ToString("yyyy-MM-dd") + " 23:59:59");
}
bc.banner_ipfrom = CommonFunction.GetClientIPNew();
if (bc.banner_ipfrom == "::1")
{
bc.banner_ipfrom = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName())[2].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["banner_content_id"]) && Request.Params["banner_image"] == oldImg)
{
bc.banner_image = oldImg;
}
if (Request.Files["banner_image"] != null && Request.Files["banner_image"].ContentLength > 0)
{
HttpPostedFileBase file = Request.Files["banner_image"];
if (file.ContentLength > int.Parse(minValue) * 1024 && file.ContentLength < int.Parse(maxValue) * 1024)
{
NewName = Path.GetFileName(file.FileName);
bool result = false;
string filename = NewName.Substring(0, NewName.LastIndexOf("."));
//獲得文件的後綴名
fileExtention = NewName.Substring(NewName.LastIndexOf(".")).ToLower();
//新的文件名是哈希字符串
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
NewFileName = hash.Md5Encrypt(filename, "32");
string firstFolder = NewFileName.Substring(0, 2) + "/";
string secondFolder = NewFileName.Substring(2, 2) + "/";
NewFileName = NewFileName + fileExtention;
NewName = NewFileName;
string ServerPath = string.Empty;
string localPromoDirectory = Server.MapPath(localPromoPath);
if (!System.IO.Directory.Exists(localPromoDirectory))
{
System.IO.Directory.CreateDirectory(localPromoDirectory);
}
FTP ftp = new FTP();
string directorys = promoPath + firstFolder + secondFolder;
ftp.MakeMultiDirectory(imgLocalPath+"/", directorys.Substring(1, directorys.Length - 2).Split('/'), ftpuser, ftppwd);
//NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(localPromoPath + firstFolder + secondFolder);
string ErrorMsg = string.Empty;
//上傳
result = fileLoad.UpLoadFile(file, ServerPath, imgLocalPath + directorys + NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (!result)
{
json = "{success:false,msg:'圖片上傳失敗!'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
bc.banner_image = NewName;
string oldImgPath = string.Empty;
string ftppath = string.Empty;
if (oldImg.Length >= 4)
{
oldImgPath = localPromoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/" + oldImg;
}
if (System.IO.File.Exists(Server.MapPath(oldImgPath)))
{
ftppath=imgLocalPath + promoPath + oldImg.Substring(0, 2) + "/" + oldImg.Substring(2, 2) + "/";
System.IO.File.Delete(Server.MapPath(oldImgPath));
FTP ftp1 = new FTP(ftppath, ftpuser, ftppwd);
List<string> tem = ftp1.GetFileList();
if (tem.Contains(oldImg))
{
FTP ftps = new FTP(ftppath + oldImg, ftpuser, ftppwd);
ftps.DeleteFile(ftppath + oldImg);
}
}
}
else
{
json = "{success:false,msg:'上傳圖片不能超過" + maxValue + "K'}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
#region 新增
if (String.IsNullOrEmpty(Request.Params["banner_content_id"]))
{
bc.banner_content_id = uint.Parse((serial.Serial_Value + 1).ToString());
if (_bcMgr.Add(bc) > 0)
{
serial.Serial_Value = serial.Serial_Value + 1;/*所在操作表的列增加*/
_ISerImplMgr.Update(serial);/*修改所在的表的列對應的值*/
json = "{success:true,msg:\"" + "新增成功！" + "\"}";
}
}
#endregion
#region 編輯
else
{
bc.banner_content_id = uint.Parse(Request.Params["banner_content_id"]);
if (_bcMgr.Update(bc) > 0)
{
json = "{success:true,msg:\"" + "修改成功！" + "\"}";
}
}
#endregion
}
catch (Exception ex)
{
json = "{success:false,msg:\"" + "異常" + "\"}";
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 記錄付款單狀態方法參考自(includes/order/order.php第391行方法)
/// </summary>
/// <param name="Order_Id"></param>
/// <param name="Modify_Master_Order_Status"></param>
/// <param name="description"></param>
/// <returns></returns>
public string order_master_status_record(string Order_Id, string Order_Status, string description = "")
{
StringBuilder sb = new StringBuilder();
StringBuilder sbt = new StringBuilder();
try
{
SerialDao serial = new SerialDao(connStr);
Serial se = new Serial();
se = serial.GetSerialById(29);// 訂單主檔狀態流水號
//se.Serial_Value += 1;
sb.AppendFormat(serial.Update(29));
// serial.Update(se);
sb.Append(@"insert into order_master_status(serial_id,order_id,order_status,status_description,status_ipfrom,status_createdate)");
sb.AppendFormat(" value((select serial_value from serial where serial_id=29),'{0}','{1}' ,", Order_Id, Order_Status);
sb.AppendFormat(" '{0}','{1}','{2}'); ", Description, IPAddress, uint.Parse(CommonFunction.GetPHPTime(DateTime.Now.ToString()).ToString()));
return sb.ToString();
}
catch (Exception ex)
{
throw new Exception("OrderDao.order_slave_status_record -->" + ex.Message + sb.ToString(), ex);
}
}
public int Insert(Serial serial)
{
try
{
return _serialDao.Insert(serial);
}
catch (Exception ex)
{
throw new Exception("SerialMgr--> Insert" + ex.Message, ex);
}
}
public string InsertVipUserGroup(VipUserGroupQuery query)
{
string json = string.Empty;
Serial serial = new Serial();
ArrayList arrList = new ArrayList();
try
{
query.k_date = DateTime.Now;
query.m_date = query.k_date;
query.k_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.m_user = query.k_user;
serial.Serial_id =72;
serial = _ISerialImpl.GetSerialById(serial.Serial_id);//根據ID得到serial_value;
query.group_id = Convert.ToUInt32(serial.Serial_Value) + 1;//將serial_value值加1就是group_id;
arrList.Add( _vipUserGroupDao.InsertVipUserGroup(query));
arrList.Add(_ISerialImpl.Update(serial.Serial_id));//update serial
if (_vipUserGroupDao.execSql(arrList))
{
json = "{success:'true',msg:" + query.group_id + "}";
}
else
{
json = "{success:'true',msg:" +0+ "}";
}
return json;
}
catch (Exception ex)
{
throw new Exception("VipUserGroupDao-->InsertVipUserGroup-->" + ex.Message, ex);
}
}
//public int Update(VendorQuery model, string update_log)
//{
// _userhistoryDao = new UserHistoryDao(connStr);
// _serialDao = new SerialDao(connStr);
// model.Replace4MySQL();
// int i = 0;
// MySqlCommand mySqlCmd = new MySqlCommand();
// MySqlConnection mySqlConn = new MySqlConnection(connStr);
// try
// {
// if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
// {
// mySqlConn.Open();
// }
// mySqlCmd.Connection = mySqlConn;
// mySqlCmd.Transaction = mySqlConn.BeginTransaction();
// mySqlCmd.CommandType = System.Data.CommandType.Text;
// model.content = ReturnHistoryCon(model).ToString();
// #region 處理vendor表
// mySqlCmd.CommandText = UpdateVendor(model);
// i += mySqlCmd.ExecuteNonQuery();
// #endregion
// #region 處理userhistory表
// mySqlCmd.CommandText += _userhistoryDao.Save(model);
// i += mySqlCmd.ExecuteNonQuery();
// #endregion
// #region 處理table_change_log 記錄供應商資料異動
// if (!string.IsNullOrEmpty(update_log))
// {
// update_log = update_log.TrimEnd('#');//去掉最後一個#
// string[] arr_log = update_log.Split('#');//分離每條記錄
// foreach (string item in arr_log)
// {
// }
// }
// #endregion
// mySqlCmd.Transaction.Commit();
// }
// catch (Exception ex)
// {
// mySqlCmd.Transaction.Rollback();
// throw new Exception("VendorDao-->Update-->" + ex.Message, ex);
// }
// finally
// {
// if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
// {
// mySqlConn.Close();
// }
// }
// return i;
//}
public int Add(VendorQuery model)
{
model.Replace4MySQL();
int i = 0;
StringBuilder sql = new StringBuilder();
MySqlCommand mySqlCmd = new MySqlCommand();
MySqlConnection mySqlConn = new MySqlConnection(connStr);
try
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Closed)
{
mySqlConn.Open();
}
mySqlCmd.Connection = mySqlConn;
mySqlCmd.Transaction = mySqlConn.BeginTransaction();
mySqlCmd.CommandType = System.Data.CommandType.Text;
#region 獲取vendor_id
mySqlCmd.CommandText = _serialDao.Update(10);
sql.Append(mySqlCmd.CommandText);
model.vendor_id = Convert.ToUInt32(mySqlCmd.ExecuteScalar());
#endregion
#region 獲取vendor_code
mySqlCmd.CommandText = "select max(vendor_code)as vendor_code from vendor;";
sql.Append(mySqlCmd.CommandText);
string tempCode = mySqlCmd.ExecuteScalar().ToString();
int nowYear = Convert.ToInt32(DateTime.Today.Year.ToString().Substring(2));
int nowDays = DateTime.Today.DayOfYear;
int nCode_4 = 1;
if (!string.IsNullOrEmpty(tempCode))
{
int tCode_2 = Convert.ToInt32(tempCode.Substring(1, 2));
int tCode_3 = Convert.ToInt32(tempCode.Substring(3, 3));
int tCode_4 = Convert.ToInt32(tempCode.Substring(6));
if (tCode_2 == nowYear && tCode_3 == nowDays)
{
nCode_4 = tCode_4 + 1;
}
}
string tYear = StrPad_Left(nowYear.ToString(), 2);
string tDays = StrPad_Left(nowDays.ToString(), 3);
model.vendor_code = "V" + tYear + tDays + StrPad_Left(nCode_4.ToString(), 4);
#endregion
model.content = ReturnHistoryCon(model).ToString();
#region 獲取erp_id
if (!string.IsNullOrEmpty(model.prod_cate) && !string.IsNullOrEmpty(model.buy_cate)
&& !string.IsNullOrEmpty(model.tax_type)
&& model.buy_cate.StartsWith(model.prod_cate))
{
//獲取serial_id;
Serial serModel = _serialDao.GetSerialById(77);
if (serModel == null)
{
serModel = new Serial();
serModel.Serial_id = 77;
serModel.Serial_Value = 500;//默認從500開始
mySqlCmd.CommandText = _serialDao.InsertStr(serModel);
sql.Append(mySqlCmd.CommandText);
i += mySqlCmd.ExecuteNonQuery();
}
mySqlCmd.CommandText = _serialDao.Update(77);//77代表erp_id的serial
sql.Append(mySqlCmd.CommandText);
model.serial = mySqlCmd.ExecuteScalar().ToString();
if (!string.IsNullOrEmpty(model.serial))
{
model.erp_id = model.buy_cate + CommonFunction.Supply(model.serial, "0", 5) + model.tax_type;
if (IsExitErpID(model.erp_id) > 0)
{
i = -1;
return i;
}
}
}
#endregion
#region 處理vendor表
mySqlCmd.CommandText = InsertVendor(model);
sql.Append(mySqlCmd.CommandText);
i += mySqlCmd.ExecuteNonQuery();
#endregion
#region 處理userhistory表
mySqlCmd.CommandText = _userhistoryDao.Save(model);
sql.Append(mySqlCmd.CommandText);
i += mySqlCmd.ExecuteNonQuery();
#endregion
mySqlCmd.Transaction.Commit();
}
catch (Exception ex)
{
mySqlCmd.Transaction.Rollback();
throw new Exception("VendorDao-->Add-->" + ex.Message + sql.ToString(), ex);
}
finally
{
if (mySqlConn != null && mySqlConn.State == System.Data.ConnectionState.Open)
{
mySqlConn.Close();
}
}
return i;
}
public DataTable GetNextSerial(Serial serial)
{
StringBuilder sql = new StringBuilder();
try
{
DataTable _dt = _dbAccess.getDataTable(_serial.Update(serial.Serial_id));
return _dt;
}
catch (Exception ex)
{
throw new Exception("OrderMasterDao-->GetNextSerial-->" + sql.ToString() + ex.Message, ex);
}
}
