public static int CheckInsert(PaymentEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("PAYMENTCODE",OracleType.VarChar),
new OracleParameter("PAYMENTNM",OracleType.VarChar)
};
PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
parm[0].Value = dbParm.PaymentID;
parm[1].Value = dbParm.Name_CN;
paymentEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Payment", "t_lm_b_payment_sigle", false, parm);
if (paymentEntity.QueryResult.Tables.Count > 0 && paymentEntity.QueryResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static PaymentEntity Select(PaymentEntity paymentEntity)
{
paymentEntity.LogMessages.MsgType = MessageType.INFO;
paymentEntity.LogMessages.Content = _nameSpaceClass + "Select";
LoggerHelper.LogWriter(paymentEntity.LogMessages);
try
{
return PaymentDA.Select(paymentEntity);
}
catch (Exception ex)
{
paymentEntity.LogMessages.MsgType = MessageType.ERROR;
paymentEntity.LogMessages.Content = _nameSpaceClass + "Select Error: " + ex.Message;
LoggerHelper.LogWriter(paymentEntity.LogMessages);
throw ex;
}
}
public static int Insert(PaymentEntity paymentEntity)
{
if (paymentEntity.PaymentDBEntity.Count == 0)
{
return 0;
}
if (paymentEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(paymentEntity) > 0)
{
return 2;
}
PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
List<CommandInfo> sqlList = new List<CommandInfo>();
CommandInfo InsertLmPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTCODE",OracleType.VarChar),
new OracleParameter("PAYMENTNM",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("T_LM_B_PAYMENT_SEQ");
lmParm[1].Value = dbParm.PaymentID;
lmParm[2].Value = dbParm.Name_CN;
InsertLmPaymentInfo.SqlName = "Payment";
InsertLmPaymentInfo.SqlId = "t_lm_b_payment_insert";
InsertLmPaymentInfo.Parameters = lmParm;
sqlList.Add(InsertLmPaymentInfo);
PaymentEntity platformList = CommonSelect(paymentEntity);
if (platformList.QueryResult.Tables.Count > 0 && platformList.QueryResult.Tables[0].Rows.Count > 0)
{
foreach (DataRow drRow in platformList.QueryResult.Tables[0].Rows)
{
CommandInfo InsertCsPaymentInfo = new CommandInfo();
OracleParameter[] csParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTID",OracleType.VarChar),
new OracleParameter("PLATFORM_ID",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
csParm[0].Value = getMaxIDfromSeq("T_LM_B_PAYMENT_PLAT_SEQ");
csParm[1].Value = dbParm.PaymentID;
csParm[2].Value = drRow["PlatformCODE"].ToString();
csParm[3].Value = "0";
InsertCsPaymentInfo.SqlName = "Payment";
InsertCsPaymentInfo.SqlId = "t_lm_b_payment_plat_insert";
InsertCsPaymentInfo.Parameters = csParm;
sqlList.Add(InsertCsPaymentInfo);
}
}
DbManager.ExecuteSqlTran(sqlList);
//DataCommand cmd = DataCommandManager.GetDataCommand("InsertCityList");
//foreach (PaymentDBEntity dbParm in paymentEntity.PaymentDBEntity)
//{
// cmd.SetParameterValue("@ChannelID", dbParm.ChannelID);
// cmd.SetParameterValue("@NameCN", dbParm.Name_CN);
// cmd.SetParameterValue("@NameEN", PinyinHelper.GetPinyin(dbParm.Name_CN));
// cmd.SetParameterValue("@OnlineStatus", dbParm.OnlineStatus);
// cmd.SetParameterValue("@Remark", dbParm.Remark);
// cmd.SetParameterValue("@CreateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.SetParameterValue("@UpdateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
return 1;
}
public static PaymentEntity CommonSelect(PaymentEntity paymentEntity)
{
paymentEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Payment", "t_lm_b_platform", false);
return paymentEntity;
}
public static int Update(PaymentEntity paymentEntity)
{
if (paymentEntity.PaymentDBEntity.Count == 0)
{
return 0;
}
if (paymentEntity.LogMessages == null)
{
return 0;
}
if (CheckUpdate(paymentEntity) > 0)
{
return 2;
}
List<CommandInfo> sqlList = new List<CommandInfo>();
bool iflag = true;
string PaymentID = "";
foreach(PaymentDBEntity paymentDBEntity in paymentEntity.PaymentDBEntity)
{
if (iflag)
{
PaymentEntity commonEntity = new PaymentEntity();
commonEntity.PaymentDBEntity = new List<PaymentDBEntity>();
PaymentDBEntity commonpaycodeDBEntity = new PaymentDBEntity();
commonpaycodeDBEntity.PaymentNo = paymentDBEntity.PaymentNo.ToString();
commonEntity.PaymentDBEntity.Add(commonpaycodeDBEntity);
DataSet dsResult = Select(commonEntity).QueryResult;
PaymentID = (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) ? dsResult.Tables[0].Rows[0]["paymentcode"].ToString() : "";
iflag = false;
}
if (paymentDBEntity.UpdatType.Equals("1"))
{
CommandInfo InsertCsMainPaymentInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTNM",OracleType.VarChar)
};
lmParm[0].Value = int.Parse(paymentDBEntity.PaymentNo.ToString());
lmParm[1].Value = paymentDBEntity.Name_CN;
InsertCsMainPaymentInfo.SqlName = "Payment";
InsertCsMainPaymentInfo.SqlId = "t_lm_b_payment_update";
InsertCsMainPaymentInfo.Parameters = lmParm;
sqlList.Add(InsertCsMainPaymentInfo);
}
else
{
CommandInfo InsertCsPaymentInfo = new CommandInfo();
OracleParameter[] csParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTID",OracleType.VarChar),
new OracleParameter("PLATFORM_ID",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar)
};
csParm[0].Value = (string.IsNullOrEmpty(paymentDBEntity.PaymentNo)) ? getMaxIDfromSeq("T_LM_B_PAYMENT_PLAT_SEQ") : int.Parse(paymentDBEntity.PaymentNo.ToString());
csParm[1].Value = PaymentID;
csParm[2].Value = paymentDBEntity.PaymFormID;
csParm[3].Value = paymentDBEntity.OnlineStatus;
InsertCsPaymentInfo.SqlName = "Payment";
InsertCsPaymentInfo.SqlId = "t_lm_b_payment_plat_update";
InsertCsPaymentInfo.Parameters = csParm;
sqlList.Add(InsertCsPaymentInfo);
}
}
DbManager.ExecuteSqlTran(sqlList);
//OracleParameter[] parm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("ONLINESTATUS",OracleType.VarChar)
// };
//PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
//parm[0].Value = dbParm.PaymentID;
//parm[1].Value = dbParm.OnlineStatus;
//DbManager.ExecuteSql("Payment", "t_cs_payment_update", parm);
//DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCityList");
//foreach (PaymentDBEntity dbParm in paymentEntity.PaymentDBEntity)
//{
// cmd.SetParameterValue("@ChannelNo", dbParm.ChannelNo);
// cmd.SetParameterValue("@ChannelID", dbParm.ChannelID);
// cmd.SetParameterValue("@NameCN", dbParm.Name_CN);
// cmd.SetParameterValue("@NameEN", PinyinHelper.GetPinyin(dbParm.Name_CN));
// cmd.SetParameterValue("@OnlineStatus", dbParm.OnlineStatus);
// cmd.SetParameterValue("@Remark", dbParm.Remark);
// cmd.SetParameterValue("@UpdateUser", (paymentEntity.LogMessages != null) ? paymentEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
return 1;
}
public static PaymentEntity Select(PaymentEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("PAYMENTNAME",OracleType.VarChar),
new OracleParameter("StartDTime",OracleType.VarChar),
new OracleParameter("EndDTime",OracleType.VarChar)
};
PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
if (String.IsNullOrEmpty(dbParm.PaymentNo))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.PaymentNo;
}
if (String.IsNullOrEmpty(dbParm.Name_CN))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.Name_CN;
}
//if (String.IsNullOrEmpty(dbParm.OnlineStatus))
//{
// parm[1].Value = DBNull.Value;
//}
//else
//{
// parm[1].Value = dbParm.OnlineStatus;
//}
if (String.IsNullOrEmpty(dbParm.StartDTime))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.StartDTime;
}
if (String.IsNullOrEmpty(dbParm.EndDTime))
{
parm[3].Value = DBNull.Value;
}
else
{
parm[3].Value = dbParm.EndDTime;
}
paymentEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Payment", "t_lm_b_payment", false, parm);
return paymentEntity;
}
public static PaymentEntity PlatFormSelect(PaymentEntity paymentEntity)
{
OracleParameter[] parm ={
new OracleParameter("PAYMENTID",OracleType.VarChar)
};
PaymentDBEntity dbParm = (paymentEntity.PaymentDBEntity.Count > 0) ? paymentEntity.PaymentDBEntity[0] : new PaymentDBEntity();
if (String.IsNullOrEmpty(dbParm.PaymentNo))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.PaymentNo;
}
paymentEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("Payment", "t_lm_b_payment_all", false, parm);
return paymentEntity;
}