public static DataSet CheckCity(CityEntity cityEntity)
{
OracleParameter[] parm ={
new OracleParameter("CITYID",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
parm[0].Value = dbParm.CityID;
return HotelVp.Common.DBUtility.DbManager.Query("City", "t_fc_city_sigle",false, parm);
}
public static CityEntity FOGMainSelect(CityEntity cityEntity)
{
OracleParameter[] parm ={
new OracleParameter("CITYID",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
parm[0].Value = dbParm.CityID;
cityEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "t_lm_b_city_main_fog", false, parm);
return cityEntity;
}
public static int CheckInsert(CityEntity cityEntity)
{
OracleParameter[] parm ={
new OracleParameter("CITYID",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
parm[0].Value = dbParm.CityID;
cityEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "t_lm_b_city_sigle", false, parm);
if (cityEntity.QueryResult.Tables.Count > 0 && cityEntity.QueryResult.Tables[0].Rows.Count > 0)
{
return 1;
}
return 0;
}
public static int Insert(CityEntity cityEntity)
{
cityEntity.LogMessages.MsgType = MessageType.INFO;
cityEntity.LogMessages.Content = _nameSpaceClass + "Insert";
LoggerHelper.LogWriter(cityEntity.LogMessages);
try
{
return CityDA.Insert(cityEntity);
}
catch (Exception ex)
{
cityEntity.LogMessages.MsgType = MessageType.ERROR;
cityEntity.LogMessages.Content = _nameSpaceClass + "Insert Error: " + ex.Message;
LoggerHelper.LogWriter(cityEntity.LogMessages);
throw ex;
}
}
public static CityEntity CommonSelectFogToCity(CityEntity cityEntity)
{
cityEntity.LogMessages.MsgType = MessageType.INFO;
cityEntity.LogMessages.Content = _nameSpaceClass + "CommonSelectFogToCity";
LoggerHelper.LogWriter(cityEntity.LogMessages);
try
{
return CityDA.SelectFogToCity(cityEntity);
}
catch (Exception ex)
{
cityEntity.LogMessages.MsgType = MessageType.ERROR;
cityEntity.LogMessages.Content = _nameSpaceClass + "CommonSelectFogToCity Error: " + ex.Message;
LoggerHelper.LogWriter(cityEntity.LogMessages);
throw ex;
}
}
public static int Insert(CityEntity cityEntity)
{
if (cityEntity.CityDBEntity.Count == 0)
{
return 0;
}
if (cityEntity.LogMessages == null)
{
return 0;
}
if (CheckInsert(cityEntity) > 0)
{
return 2;
}
DataSet dsCity = CheckCity(cityEntity);
if (dsCity.Tables.Count == 0 || dsCity.Tables[0].Rows.Count == 0)
{
return 3;
}
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
//List<CommandInfo> sqlList = new List<CommandInfo>();
//CommandInfo InsertLmCityInfo = new CommandInfo();
OracleParameter[] lmParm ={
new OracleParameter("ID",OracleType.Number),
new OracleParameter("CITYID",OracleType.VarChar)
//,
//new OracleParameter("Name_CN",OracleType.VarChar),
//new OracleParameter("Name_EN",OracleType.VarChar),
//new OracleParameter("Area_ID",OracleType.VarChar)
};
lmParm[0].Value = getMaxIDfromSeq("T_LM_B_CITY_SEQ");
lmParm[1].Value = dbParm.CityID;
//lmParm[2].Value = dsCity.Tables[0].Rows[0]["name_zh"].ToString();
//lmParm[3].Value = dsCity.Tables[0].Rows[0]["name_en"].ToString();
//lmParm[4].Value = dsCity.Tables[0].Rows[0]["areaid"].ToString();
//InsertLmCityInfo.SqlName = "City";
//InsertLmCityInfo.SqlId = "t_lm_b_city_insert";
//InsertLmCityInfo.Parameters = lmParm;
DbManager.ExecuteSql("City", "t_lm_b_city_insert", lmParm);
//CommandInfo InsertCsCityInfo = new CommandInfo();
//OracleParameter[] csParm ={
// new OracleParameter("ID",OracleType.Number),
// new OracleParameter("CITYID",OracleType.VarChar),
// new OracleParameter("ONLINESTATUS",OracleType.VarChar)
// };
//csParm[0].Value = getMaxIDfromSeq("T_CS_CITY_SEQ");
//csParm[1].Value = lmParm[0].Value;
//csParm[2].Value = "0";
//InsertCsCityInfo.SqlName = "City";
//InsertCsCityInfo.SqlId = "t_cs_city_insert";
//InsertCsCityInfo.Parameters = csParm;
//sqlList.Add(InsertLmCityInfo);
//sqlList.Add(InsertCsCityInfo);
//DbManager.ExecuteSqlTran(sqlList);
//DataCommand cmd = DataCommandManager.GetDataCommand("InsertCityList");
//foreach (CityDBEntity dbParm in cityEntity.CityDBEntity)
//{
// 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", (cityEntity.LogMessages != null) ? cityEntity.LogMessages.Userid : "");
// cmd.SetParameterValue("@UpdateUser", (cityEntity.LogMessages != null) ? cityEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
return 1;
}
public static CityEntity CommonSelect(CityEntity cityEntity)
{
cityEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "t_fc_city", false);
return cityEntity;
}
public static int Update(CityEntity cityEntity)
{
if (cityEntity.CityDBEntity.Count == 0)
{
return 0;
}
if (cityEntity.LogMessages == null)
{
return 0;
}
OracleParameter[] parm ={
new OracleParameter("CITYID",OracleType.VarChar),
new OracleParameter("ELCITYID",OracleType.VarChar),
new OracleParameter("NAMECN",OracleType.VarChar),
new OracleParameter("SEQ",OracleType.VarChar),
new OracleParameter("PINYIN",OracleType.VarChar),
new OracleParameter("PINYINSHORT",OracleType.VarChar),
new OracleParameter("LONGITUDE",OracleType.VarChar),
new OracleParameter("LATITUDE",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar),
new OracleParameter("TYPE",OracleType.VarChar),
new OracleParameter("ISHOT",OracleType.VarChar),
new OracleParameter("SALEHOUR",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
parm[0].Value = dbParm.CityID;
parm[1].Value = dbParm.ElCityID;
parm[2].Value = dbParm.Name_CN;
parm[3].Value = dbParm.SEQ;
parm[4].Value = dbParm.Pinyin;
parm[5].Value = dbParm.PinyinS;
parm[6].Value = dbParm.Longitude;
parm[7].Value = dbParm.Latitude;
parm[8].Value = dbParm.OnlineStatus;
parm[9].Value = dbParm.CityType;
parm[10].Value = dbParm.IsHot;
parm[11].Value = dbParm.SaleHour;
DbManager.ExecuteSql("City", "t_lm_b_city_update", parm);
//DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCityList");
//foreach (CityDBEntity dbParm in cityEntity.CityDBEntity)
//{
// 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", (cityEntity.LogMessages != null) ? cityEntity.LogMessages.Userid : "");
// cmd.ExecuteNonQuery();
//}
return 1;
}
public static CityEntity SelectFogToCity(CityEntity cityEntity)
{
//改参数
OracleParameter[] parm ={
new OracleParameter("name_zh",OracleType.VarChar),
new OracleParameter("name_en",OracleType.VarChar),
new OracleParameter("pinyin_short",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
if (String.IsNullOrEmpty(dbParm.Name_CN))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.Name_CN;
}
if (String.IsNullOrEmpty(dbParm.Name_EN))
{
parm[1].Value = DBNull.Value;
}
else
{
parm[1].Value = dbParm.Name_EN;
}
if (String.IsNullOrEmpty(dbParm.PinyinS))
{
parm[2].Value = DBNull.Value;
}
else
{
parm[2].Value = dbParm.PinyinS;
}
cityEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "fog_t_city", false, parm);
return cityEntity;
}
public static CityEntity Select(CityEntity cityEntity)
{
OracleParameter[] parm ={
new OracleParameter("CITYNAME",OracleType.VarChar),
new OracleParameter("ONLINESTATUS",OracleType.VarChar),
new OracleParameter("StartDTime",OracleType.VarChar),
new OracleParameter("EndDTime",OracleType.VarChar)
};
CityDBEntity dbParm = (cityEntity.CityDBEntity.Count > 0) ? cityEntity.CityDBEntity[0] : new CityDBEntity();
if (String.IsNullOrEmpty(dbParm.Name_CN))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].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;
}
cityEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("City", "t_lm_b_city", false, parm);
return cityEntity;
}
//protected void gridViewCSReviewUserList_RowDeleting(object sender, GridViewDeleteEventArgs e)
//{
// string strID = gridViewCSReviewUserList.DataKeys[e.RowIndex].Value.ToString();
// _userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
// _commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
// _userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
// _userEntity.LogMessages.Username = UserSession.Current.UserDspName;
// _userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
// _userEntity.UserDBEntity = new List<UserDBEntity>();
// UserDBEntity usergroupEntity = new UserDBEntity();
// usergroupEntity.UserNo = strID;
// _userEntity.UserDBEntity.Add(usergroupEntity);
// int iResult = UserGroupBP.DeleteConsultRoomUser(_userEntity);
// _commonEntity.LogMessages = _userEntity.LogMessages;
// _commonEntity.CommonDBEntity = new List<CommonDBEntity>();
// CommonDBEntity commonDBEntity = new CommonDBEntity();
// commonDBEntity.Event_Type = "巡房条件-删除";
// commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
// string conTent = GetLocalResourceObject("EventDeleteMessage").ToString();
// conTent = string.Format(conTent, usergroupEntity.UserNo);
// commonDBEntity.Event_Content = conTent;
// if (iResult == 1)
// {
// commonDBEntity.Event_Result = GetLocalResourceObject("DelSuccess").ToString();
// messageContent.InnerHtml = GetLocalResourceObject("DelSuccess").ToString();
// BindReviewUserListGrid();
// //ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnDelCompleteStyle();", true);
// }
// else
// {
// commonDBEntity.Event_Result = GetLocalResourceObject("Error5").ToString();
// messageContent.InnerHtml = GetLocalResourceObject("Error5").ToString();
// }
// _commonEntity.CommonDBEntity.Add(commonDBEntity);
// CommonBP.InsertEventHistory(_commonEntity);
//}
/// <summary>
/// 分配所有 城市 下面 所有酒店 到 该用户名下
/// 获取 该用户已绑定信息 获取所有城市 绑定到该用户名下
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAllotAllCitys_Click(object sender, EventArgs e)
{
#region 判断是否 有用户
if (String.IsNullOrEmpty(hidSelecUserID.Value.Trim()))
{
messageContent.InnerHtml = "订单审核任务分配绑定城市失败，请选择用户！";
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
if (!hidSelecUserID.Value.Trim().Contains("[") || !hidSelecUserID.Value.Trim().Contains("]"))
{
messageContent.InnerHtml = "订单审核任务分配绑定城市失败，请选择用户！";
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScript", "BtnCompleteStyle();", true);
return;
}
#endregion
hidUserID.Value = hidSelecUserID.Value;
#region 获取该用户 已绑定的 城市 酒店 商圈 信息
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
UserDBEntity usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
_userEntity.UserDBEntity.Add(usergroupEntity);
DataSet dsResult = UserSearchBP.ReviewConsultPOrderUserSelect(_userEntity).QueryResult;//用户绑定信息
#endregion
#region 获取所有城市
CityEntity _cityEntity = new CityEntity();
_cityEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_cityEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_cityEntity.LogMessages.Username = UserSession.Current.UserDspName;
_cityEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_cityEntity.CityDBEntity = new List<CityDBEntity>();
CityDBEntity cityDBEntity = new CityDBEntity();
_cityEntity.CityDBEntity.Add(cityDBEntity);
DataSet dsCityResult = CityBP.Select(_cityEntity).QueryResult;
#endregion
for (int i = 0; i < dsCityResult.Tables[0].Rows.Count; i++)
{
DataRow[] rows = dsResult.Tables[0].Select("CONSULTVAL='" + dsCityResult.Tables[0].Rows[i]["CONSULTVAL"].ToString() + "'");
if (rows.Length == 0)//当前城市没有绑定 将该城市 绑定到该用户下面
{
string CityID = dsCityResult.Tables[0].Rows[i]["cityID"].ToString();
#region 保存城市 记录日志
_userEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_commonEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_userEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_userEntity.LogMessages.Username = UserSession.Current.UserDspName;
_userEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_userEntity.UserDBEntity = new List<UserDBEntity>();
usergroupEntity = new UserDBEntity();
usergroupEntity.UserID = hidUserID.Value.Trim().Substring((hidUserID.Value.Trim().IndexOf('[') + 1), (hidUserID.Value.Trim().IndexOf(']') - 1));
usergroupEntity.CityID = CityID;
usergroupEntity.RType = "0";//城市
_userEntity.UserDBEntity.Add(usergroupEntity);
int iResult = UserGroupBP.InsertConsultPOrderUser(_userEntity);
_commonEntity.LogMessages = _userEntity.LogMessages;
_commonEntity.CommonDBEntity = new List<CommonDBEntity>();
CommonDBEntity commonDBEntity = new CommonDBEntity();
commonDBEntity.Event_Type = "订单审核任务分配-All-批量城市-保存";
commonDBEntity.Event_ID = hidUserID.Value.ToString().Trim();
string conTent = GetLocalResourceObject("EventInsertMessage").ToString();
string conval = usergroupEntity.CityID;
conTent = string.Format(conTent, usergroupEntity.UserID, usergroupEntity.RType, conval);
commonDBEntity.Event_Content = conTent;
if (iResult == 1)
{
commonDBEntity.Event_Result = GetLocalResourceObject("InsertSuccess").ToString();
}
else if (iResult == 2)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error2").ToString();
}
else if (iResult == 3)
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error3").ToString();
}
else
{
commonDBEntity.Event_Result = GetLocalResourceObject("Error4").ToString();
}
_commonEntity.CommonDBEntity.Add(commonDBEntity);
CommonBP.InsertEventHistory(_commonEntity);
#endregion
}
}
ScriptManager.RegisterStartupScript(this.UpdatePanel2, this.GetType(), "updateScriptAll", "BtnCompleteStyle();", true);
}