/// <summary>
/// 用户充值
/// </summary>
/// <param name="idcard"></param>
/// <param name="fee"></param>
public string DepositUserWallet(string idcard, string fee)
{
Dictionary <string, string> ret = new Dictionary <string, string>();
ret.Add("ret", "0");
string sql = "select * from v_CF_User_View where IDCard='" + idcard + "'";
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
string userId = dt.Rows[0]["UserID"].ToString();
sql = "select * from CF_User_Extenal where UserID=" + dt.Rows[0]["UserID"].ToString();
dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
string feeRate = ConfigurationManager.AppSettings["FeeRate"];
if (dt.Rows.Count > 0)
{
decimal wallet = decimal.Parse(dt.Rows[0]["Wallet"].ToString()) + decimal.Parse(fee);
sql = "update CF_User_Extenal set wallet = " + wallet.ToString() + " where ExternalID=" + dt.Rows[0]["ExternalID"].ToString();
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
ret.Add("fee", wallet.ToString());
}
else
{
decimal wallet = decimal.Parse(fee);
sql = "Insert into CF_User_Extenal values (" + userId + "," + wallet.ToString() + ",0,'','','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
ret.Add("fee", wallet.ToString());
}
return(JSONHelper.ToJson(ret));
}
public void DeleteCommunityRelationship(string guid)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("delete from Rent_user_community_relationship where t_fun_guid='" + guid + "'");
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
public void DeleteCorporation(string corpId)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("delete from t_corporation where co_corp_id='" + corpId + "'");
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
/// <summary>
/// 添加消费记录
/// </summary>
/// <param name="rennteeIDCard"></param>
/// <param name="ownerIDCard"></param>
/// <param name="fee"></param>
/// <param name="payType">0：微信，1：钱包</param>
/// <returns></returns>
public string AddBillLog(string rennteeIDCard, string ownerIDCard, string fee, string payType)
{
Dictionary <string, string> ret = new Dictionary <string, string>();
try
{
string rate = ConfigurationManager.AppSettings["FeeRate"];
string sql = "Insert into sys_bill values ('" + Guid.NewGuid().ToString() + "','房费','" + rennteeIDCard + "','" + ownerIDCard + "','" + payType + "','0','" + DateTime.Now.ToString() + "','收入'," + fee + ")";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
decimal rateFee = 0;
rateFee = decimal.Parse(fee) * decimal.Parse(rate);
if (rateFee > 0)
{
sql = "Insert into sys_bill values ('" + Guid.NewGuid().ToString() + "','平台手续费','" + ownerIDCard + "','云上之家服务平台','" + payType + "','1','" + DateTime.Now.ToString() + "','支出'," + rateFee.ToString() + ")";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
ret.Add("ret", "0");
ret.Add("msg", "Success");
}
catch (Exception ex)
{
ret.Add("ret", "1");
ret.Add("msg", ex.Message);
}
return(JSONHelper.ToJson(ret));
}
public void DeleteCorporation(string rentNo)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("delete from Rent_Rent where RentNo='" + rentNo + "'");
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
public void UpdateRent(RentInfo rentInfo)
{
StringBuilder strSql = new StringBuilder();
if (IsExistsRentNo(rentInfo.RentNo))
{
//Update
strSql.Append("Update Rent_Rent set ");
strSql.Append(" RDName='" + rentInfo.RDName + "',RSName='" + rentInfo.RSName + "',RRName='" + rentInfo.RRName + "',");
strSql.Append(" RPSParentName = '" + rentInfo.RPSParentName + "', RPSName = '" + rentInfo.RPSName + "',RAddress='" + rentInfo.RAddress + "',RDoor='" + rentInfo.RDoor + "',");
strSql.Append(" RTotalDoor='" + rentInfo.RTotalDoor + "',RRoomType='" + rentInfo.RRoomType + "',RDirection='" + rentInfo.RDirection + "',");
strSql.Append(" RStructure='" + rentInfo.RStructure + "',RBuildingType='" + rentInfo.RBuildingType + "',RFloor='" + rentInfo.RFloor + "', ");
strSql.Append(" RTotalFloor='" + rentInfo.RTotalFloor + "', RHouseAge='" + rentInfo.RHouseAge + "',RProperty='" + rentInfo.RProperty + "', ");
strSql.Append(" RRentArea='" + rentInfo.RRentArea + "' ,RBuildArea='" + rentInfo.RBuildArea + "', ROwner='" + rentInfo.ROwner + "',");
strSql.Append(" ROwnerTel='" + rentInfo.ROwnerTel + "' ,RIDCard='" + rentInfo.RIDCard + "', RLocationDescription='" + rentInfo.RLocationDescription + "',");
strSql.Append(" RMapID='" + rentInfo.RMapID + "' ,RPSID='" + rentInfo.RPSID + "',");
strSql.Append(" RModifiedBy='" + rentInfo.RModifiedBy + "',");
strSql.Append(" RModifiedDate='" + rentInfo.RModifiedDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "',RRentType='" + rentInfo.RentType + "',ROwnType='" + rentInfo.OwnType + "'");
strSql.Append(" where RentNo = '" + rentInfo.RentNo + "'");
SysLogHelper.AddLog(rentInfo.RModifiedBy, "修改房源信息ID：" + rentInfo.RentNo, "修改-房源信息");
}
else
{
//Insert
strSql.Append("Insert into Rent_Rent ([RentNO],[RDName],[RSName],[RRName]," +
"[RPSName],[RAddress],[RDoor],[RTotalDoor]," +
"[RRoomType],[RDirection],[RStructure],[RBuildingType]," +
"[RFloor] ,[RTotalFloor],[RHouseAge] ,[RProperty]," +
"[RRentArea],[RBuildArea],[ROwner],[ROwnerTel]," +
"[RIDCard],[RLocationDescription],[RMapID],[RPSID]," +
"[RCreatedBy],[RCreatedDate],[RModifiedBy]," +
"[RModifiedDate],[RPSParentName],[RRentType],[ROwntype],[IsAvailable],[IsObsoleted],[RentNumber]) values (");
strSql.Append("'" + rentInfo.RentNo + "','" + rentInfo.RDName + "','" + rentInfo.RSName + "','" + rentInfo.RRName + "',");
strSql.Append("'" + rentInfo.RPSName + "','" + rentInfo.RAddress + "','" + rentInfo.RDoor + "','" + rentInfo.RTotalDoor + "',");
strSql.Append("'" + rentInfo.RRoomType + "','" + rentInfo.RDirection + "','" + rentInfo.RStructure + "','" + rentInfo.RBuildingType + "',");
strSql.Append("'" + rentInfo.RFloor + "','" + rentInfo.RTotalFloor + "','" + rentInfo.RHouseAge + "','" + rentInfo.RProperty + "',");
strSql.Append("'" + rentInfo.RRentArea + "','" + rentInfo.RBuildArea + "','" + rentInfo.ROwner + "','" + rentInfo.ROwnerTel + "',");
strSql.Append("'" + rentInfo.RIDCard + "','" + rentInfo.RLocationDescription + "','" + rentInfo.RMapID + "','" + rentInfo.RPSID + "',");
strSql.Append("'" + rentInfo.RCreatedBy + "','" + rentInfo.RCreatedDate.ToString("yyyy-MM-dd hh:mm:ss") + "','" + rentInfo.RCreatedBy + "',");
strSql.Append("'" + rentInfo.RCreatedDate.ToString("yyyy-MM-dd hh:mm:ss") + "','" + rentInfo.RPSParentName + "','" + rentInfo.RentType + "','" + rentInfo.OwnType + "','" + rentInfo.IsAvailable + "','" + rentInfo.IsObsoleted + "','0'");
strSql.Append(")");
UpdateRentExternal(rentInfo);
SysLogHelper.AddLog(rentInfo.RCreatedBy, "添加房源信息ID：" + rentInfo.RentNo, "添加-房源信息");
}
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(strSql.ToString()));
if (!string.IsNullOrEmpty(rentInfo.Longitude) && !string.IsNullOrEmpty(rentInfo.Latitude))
{
StringBuilder strSql1 = new StringBuilder();
if (IsExistsMapInfo(rentInfo.RentNo))
{
strSql1.Append("Update Rent_Map set Longitude='" + rentInfo.Longitude + "', Latitude='" + rentInfo.Latitude + "' where RentNO='" + rentInfo.RentNo + "'");
}
else
{
strSql1.Append("Insert into Rent_Map values('" + rentInfo.RentNo + "', '" + rentInfo.Longitude + "', '" + rentInfo.Latitude + "')");
}
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(strSql1.ToString()));
}
}
public void DeleteMessage(string msgId)
{
string guid = Guid.NewGuid().ToString();
string sql = "delete from t_web_text where wt_serial_id='" + msgId + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void InsertRelationShip(string userId, string region)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("insert into Rent_user_dept_relationship values ('" + Guid.NewGuid().ToString() + "'," + userId + ",'" + region + "','1','')");
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
public string GetIOLetInfos()
{
Dictionary <string, string> kv = new Dictionary <string, string>();
kv.Add("ResourceId", "iolets");
kv.Add("RequestId", "EBA1001S");
//kv.Add("Host", "http://qxw2332340157.my3w.com");
kv.Add("Token", "TJ_TIANTAJ_PS");
string retStr = LigerRM.Common.WebRequestHelper.WebRequestPoster.GetJson(IOLET_URL, kv);
Dictionary <string, string> ret = new Dictionary <string, string>();
ret = JSONHelper.FromJson <Dictionary <string, string> >(retStr);
if (ret["rsc"].ToString() == "200")
{
string sql = "delete from Motor_IOLetInfo";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
IOLets[] partRet = JSONHelper.FromJson <IOLets[]>(ret["iolets"]);
foreach (IOLets io in partRet)
{
sql = "Insert into Motor_IOLetInfo values ('" + io.id + "','" + io.name + "','" + io.parklot + "','" + DateTime.Now.ToString() + "','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
}
return(retStr);
}
public void AddLockLog(string deviceId, string action)
{
string id = Guid.NewGuid().ToString();
string sql = "insert into Rent_Lock_Logs values ('" + id + "','" + deviceId + "','" + action + "','" + DateTime.Now.ToString() + "','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public string DeleteBanner(long BannerId)
{
ReturnJosn Return = new ReturnJosn();
try
{
StringBuilder str = new StringBuilder();
str.Append("DELETE AppHome_Banner WHERE BannerId=" + BannerId);
int count = MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(str.ToString()));
if (count > 0)
{
Return.Code = "0";
Return.Msg = "删除成功！！！";
}
else
{
Return.Code = "1";
Return.Msg = "删除失败！！！";
}
return(JSONHelper.ToJson(Return));
}
catch (Exception ex)
{
Return.Code = "1";
Return.Msg = "操作失败，出现系统异常！";
return(JSONHelper.ToJson(Return));
}
}
public void UpdateAttachment(AttachmentInfo attachInfo)
{
StringBuilder sqlStr = new StringBuilder();
if (attachInfo.AttachmentID.HasValue) //update
{
}
else //Insert
{
sqlStr.Append("Insert into t_signet_attachment values(@sa_signet_id,@sa_title,@file,@sa_demo,@sa_date)");
SqlParameter[] parameters =
{
new SqlParameter("@sa_signet_id", SqlDbType.VarChar, 13),
new SqlParameter("@sa_title", SqlDbType.VarChar, 100),
new SqlParameter("@file", SqlDbType.Image),
new SqlParameter("@sa_demo", SqlDbType.VarChar, 500),
new SqlParameter("@sa_date", SqlDbType.DateTime)
};
parameters[0].Value = attachInfo.SignetID;
parameters[1].Value = attachInfo.Title;
parameters[2].Value = attachInfo.FileInfo;
parameters[3].Value = attachInfo.AttachmentDemo;
parameters[4].Value = DateTime.Now;
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString(), parameters));
}
}
public void DeleteAttachment(string attachmentId)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("Delete from t_signet_attachment where sa_attachment_id=" + attachmentId);
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
//增加一键开锁的log日志 SDK
public void AddLockNewSDKLog(string deviceId, string action, string meno, string userId)
{
string id = Guid.NewGuid().ToString();
string sql = "insert into Enterprise_OpenDoor_Log values ('" + id + "', '" + userId + "', '" + deviceId + "','" + meno + "','" + DateTime.Now.ToString() + "','','','','','" + action + "')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void UpdateMessage(string title, string content, string id)
{
string guid = Guid.NewGuid().ToString();
string sql = "update t_web_text set wt_title='" + title + "',wt_text='" + content + "' where wt_serial_id='" + id + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void DeleteRelationShip(string userId)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("delete from Rent_user_dept_relationship where t_wu_user_id=" + userId);
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString()));
}
public void UploadPersonInfo(string id, string motorNo)
{
//type: 0-出租屋，1-印章系统,2-车辆
string sql = "insert into T_Person_Info values ('" + Guid.NewGuid().ToString() + "','" + id + "','" + motorNo + "','" + motorNo + "','2','" + DateTime.Now.ToString() + "','0','','RZF','天津市河西区天塔街环湖南里','120004056','120004056','0','','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.DataSynConnectionString, MySQLHelper.CreateCommand(sql));
}
public void AddEvaluate(Evaluate info)
{
string sql = "insert into dbo.Rent_Evaluate values ('" + info.EvaluateID + "','" + info.EvaluateObject + "','" + info.EvaluateType +
"','" + DateTime.Now.ToString() + "'," + (info.EvaluateItem0.HasValue ? info.EvaluateItem0.Value.ToString() : "null") + "," + (info.EvaluateItem1.HasValue?info.EvaluateItem1.Value.ToString():"null") + ","
+ (info.EvaluateItem2.HasValue?info.EvaluateItem2.Value.ToString():"null") + "," + (info.EvaluateItem3.HasValue?info.EvaluateItem3.Value.ToString():"null") + "," + (info.EvaluateItem4.HasValue?info.EvaluateItem4.Value.ToString():"null") + ",'" + info.EvaluatePerson + "','" + info.EvaluateDesc + "')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void UpdateRentExternal(string rentNO, string desc)
{
string sql = "delete from Rent_External where Rent_NO='" + rentNO + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
sql = "insert into Rent_External values ('" + rentNO + "','" + desc + "')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void UploadPersonInfo(RentAttribute info)
{
//type: 0-出租屋，1-印章系统
RentInfo rent = new RentInfo(info.RentNo);
string sql = "insert into T_Person_Info values ('" + Guid.NewGuid().ToString() + "','" + info.RRAID.ToString() + "','" + info.RRAContactName + "','" + info.RRAIDCard + "','0','" + DateTime.Now.ToString() + "','0','','RZF','" + rent.RAddress + "','" + rent.RPSName + "','" + rent.RPSName + "','0','','')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.DataSynConnectionString, MySQLHelper.CreateCommand(sql));
}
private void TransferData(XmlNode xn)
{
foreach (XmlNode n in xn.ChildNodes)
{
XmlElement xe = (XmlElement)n;
string tableName = xe.GetAttribute("Name").ToString();
string key = xe.GetAttribute("Key").ToString();
string keyType = xe.GetAttribute("KeyType").ToString();
string optType = xe.GetAttribute("OptType").ToString();
string keyValue = xe.GetAttribute("KeyValue").ToString();
string sql = string.Empty;
DataTable dt = GetTableStructure(tableName);
//tableName += "_test";
switch (optType)
{
case "0": //insert
sql = "insert into " + tableName + " ";
string columnStr = "(";
string valueStr = "values(";
foreach (DataRow r in dt.Rows)
{
columnStr += r["COLUMN_NAME"].ToString() + ",";
valueStr += FormatValuesByType(r["DATA_TYPE"].ToString(), n.SelectSingleNode(r["COLUMN_NAME"].ToString()).InnerText) + ",";
}
columnStr = columnStr.Substring(0, columnStr.Length - 1) + ") ";
valueStr = valueStr.Substring(0, valueStr.Length - 1) + ") ";
sql = sql + columnStr + valueStr;
break;
case "1":
sql = "update " + tableName + " set ";
columnStr = "";
foreach (DataRow r in dt.Rows)
{
if (!r["COLUMN_NAME"].ToString().ToLower().Equals(key.ToLower()))
{
columnStr += r["COLUMN_NAME"].ToString() + "=" + FormatValuesByType(r["DATA_TYPE"].ToString(), n.SelectSingleNode(r["COLUMN_NAME"].ToString()).InnerText) + ",";
}
}
columnStr = columnStr.Substring(0, columnStr.Length - 1);
sql = sql + columnStr + " where " + key + "=" + FormatValuesByType(keyType, keyValue);
break;
case "2":
sql = "delete from " + tableName + " where " + key + "=" + FormatValuesByType(keyType, keyValue);
break;
}
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
}
public void DeleteICCard(string id)
{
string sql = "select * from Rent_Locks_ICCards where ID=" + id;
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
sql = "update Rent_Locks_ICCards set IsValid='0' where ID=" + id;
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
string s = string.Empty;
LockServices.IhzbAttenServiceservice client = new LockServices.IhzbAttenServiceservice();
string str = dt.Rows[0]["LockID"].ToString().PadRight(16, ' ') + dt.Rows[0]["ICCard"].ToString().PadRight(10, ' ') + s.PadRight(18, ' ') + s.PadRight(13, ' ') + s.PadRight(6, ' ') + DateTime.Parse(dt.Rows[0]["StartDate"].ToString()).ToString("yyyyMMddHHmm").Substring(2, 10) + DateTime.Parse(dt.Rows[0]["EndDate"].ToString()).ToString("yyyyMMddHHmm").Substring(2, 10) + "2";
string ret = client.hzb_SetPassengerInfo(99, "02500262", str);
}
public void UpdateCorporation(CorporationInfo corpInfo)
{
StringBuilder strSql = new StringBuilder();
if (IsExists(corpInfo.CorpID))
{
//Update
strSql.Append("Update t_corporation set ");
strSql.Append(" co_corp_name='" + corpInfo.CorpName + "',co_sort_id='" + corpInfo.SortID + "',co_alias_name='" + corpInfo.AliasName + "',");
strSql.Append(" co_full_name = '" + corpInfo.FullName + "',co_corp_class='" + corpInfo.CorpClass + "',co_type='" + corpInfo.CorpType + "',");
strSql.Append(" co_area_id='" + corpInfo.AreaID.Trim() + "',co_boss='" + corpInfo.BossName + "',co_boss_idcard='" + corpInfo.BossIDCard + "',");
strSql.Append(" co_address='" + corpInfo.Address + "',co_linker='" + corpInfo.Linker + "',co_link_way='" + corpInfo.LinkWay + "', ");
strSql.Append(" co_post_code='" + corpInfo.PostCode + "', co_tax_no='" + corpInfo.TaxNo + "',co_account_no='" + corpInfo.AccountNo + "', ");
strSql.Append(" co_password='******' ,co_other_no='" + corpInfo.OtherNo + "', co_creator='" + corpInfo.Creator + "',");
strSql.Append(" co_create_date='" + corpInfo.CreateDate.ToString("yyyy-MM-dd hh:mm:ss") + "' ,co_who_cancel='" + corpInfo.Canceller + "',");
if (corpInfo.CancelDate.HasValue)
{
strSql.Append(" co_cancel_date ='" + corpInfo.CancelDate.Value.ToString() + "',");
}
else
{
strSql.Append(" co_cancel_date = null,");
}
strSql.Append(" co_cancel_type='" + corpInfo.CancelType + "' ,co_cancel_reason='" + corpInfo.CancelReason + "',co_status='" + corpInfo.Status + "' ,");
strSql.Append(" co_memo='" + corpInfo.Memo + "' ,co_biz_id='" + corpInfo.BizNo + "'");
strSql.Append(" where co_corp_id = '" + corpInfo.CorpID + "'");
SysLogHelper.AddLog(corpInfo.Creator, "修改企业信息ID：" + corpInfo.CorpID, "修改-企业信息");
}
else
{
//Insert
strSql.Append("Insert into t_corporation values (");
strSql.Append("'" + corpInfo.CorpID + "','" + corpInfo.CorpName + "','" + corpInfo.SortID + "','" + corpInfo.AliasName + "','" + corpInfo.FullName + "',");
strSql.Append("'" + corpInfo.CorpClass + "','" + corpInfo.CorpType + "','" + corpInfo.AreaID + "','" + corpInfo.BossName + "','" + corpInfo.BossIDCard + "',");
strSql.Append("'" + corpInfo.Address + "','" + corpInfo.PostCode + "','" + corpInfo.Linker + "','" + corpInfo.LinkWay + "','" + corpInfo.TaxNo + "',");
strSql.Append("'" + corpInfo.AccountNo + "','" + corpInfo.OtherNo + "','" + corpInfo.PassWord + "','" + corpInfo.Creator + "','" + corpInfo.CreateDate.ToString("yyyy-MM-dd hh:mm:ss") + "',");
if (corpInfo.CancelDate.HasValue)
{
strSql.Append("'" + corpInfo.Canceller + "','" + corpInfo.CancelDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "',");
}
else
{
strSql.Append("'" + corpInfo.Canceller + "',null,");
}
strSql.Append("'" + corpInfo.CancelType + "','" + corpInfo.CancelReason + "','" + corpInfo.Status + "','" + corpInfo.Memo + "','" + corpInfo.BizNo + "'");
strSql.Append(")");
UpdateCorporationID(corpInfo.Region, corpInfo.RegionName);
SysLogHelper.AddLog(corpInfo.Creator, "添加企业信息ID：" + corpInfo.CorpID, "添加-企业信息");
}
MySQLHelper.ExecuteNonQuery(SqlConnString, MySQLHelper.CreateCommand(strSql.ToString()));
}
public void AddMessage(string title, string content, string reporter, string carveIds)
{
string guid = Guid.NewGuid().ToString();
string sql = "insert into t_web_text values ('" + guid + "','" + title + "','" + content + "','" + DateTime.Now.ToString() + "','" + reporter + "','A')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
if (!string.IsNullOrEmpty(carveIds))
{
foreach (string s in carveIds.Split(','))
{
sql = "insert into t_web_text_relationship values ('" + Guid.NewGuid().ToString() + "','" + guid + "','" + s + "',0,null)";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
}
}
public void UpdateRentExternal(RentInfo rentInfo, bool isService)
{
string sql = "select * from Rent_External where rent_No='" + rentInfo.RentNo + "'";
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
if (dt.Rows.Count > 0)
{
sql = "update Rent_External set HZHouseID='" + rentInfo.RHouseID.ToString() + "',HZRentID='" + rentInfo.RRentID + "',HZUploadDate='" + DateTime.Now.ToString() + "',RentRealOwner='" + rentInfo.RRealOwner + "',RentRealOwnerID='" + rentInfo.RRealIDCard + "',RentRealOwnerPhone='" + rentInfo.RRealOwnerTel + "' where rent_No='" + rentInfo.RentNo + "'";
}
else
{
sql = "insert into Rent_External values ('" + rentInfo.RentNo + "','','" + rentInfo.RHouseID + "','" + rentInfo.RRentID + "','" + DateTime.Now.ToString() + "','" + rentInfo.ROwner + "','" + rentInfo.RIDCard + "','" + rentInfo.ROwnerTel + "')";
}
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void UpdateRentExternal(RentInfo rentInfo)
{
string sql = "select * from Rent_External where rent_No='" + rentInfo.RentNo + "'";
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
if (dt.Rows.Count > 0)
{
sql = "insert into Rent_External values ('" + rentInfo.RentNo + "','','" + rentInfo.RHouseID + "','" + rentInfo.RRentID + "','" + DateTime.Now.ToString() + "','" + rentInfo.ROwner + "','" + rentInfo.RIDCard + "','" + rentInfo.ROwnerTel + "')";
}
else
{
sql = "insert into Rent_External values ('" + rentInfo.RentNo + "','','','',null,'" + rentInfo.ROwner + "','" + rentInfo.RIDCard + "','" + rentInfo.ROwnerTel + "')";
}
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void ExpiredOrders()
{
string sql = "select * from dbo.Rent_RentAttribute where rrastatus='1' or rrastatus='0'";
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
foreach (DataRow row in dt.Rows)
{
DateTime createdOn = DateTime.Parse(row["RRACreatedDate"].ToString());
if (createdOn.AddMinutes(20) < DateTime.Now)
{
sql = "update Rent_RentAttribute set RRAStatus='" + ((int)RentAttributeHelper.AttributeStatus.Expired).ToString() + "' where RRAID=" + row["RRAID"].ToString();
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
}
}
public void UpdateExternalInfo(RentAttribute info)
{
string sql = "select * from Rent_RentAttribute_External where RRAID=" + info.RRAID.ToString();
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
if (dt.Rows.Count > 0)
{
sql = "Update Rent_RentAttribute_External set HZTenantID='" + info.TenantID + "' where RRAID=" + info.RRAID.ToString();
}
else
{
sql = "Insert into Rent_RentAttribute_External values (" + info.RRAID.ToString() + ",'" + info.TenantID + "','" + DateTime.Now.ToString() + "')";
}
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void DeletePassword(string id)
{
string sql = "update Rent_Locks_Password set IsValid='0' where ID=" + id;
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
sql = "select * from Rent_Locks_Password where ID=" + id;
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
string s = string.Empty;
if (dt.Rows.Count > 0)
{
UpdatePassengerInfoToDevice(dt.Rows[0]["LockID"].ToString(), "", "", "", dt.Rows[0]["Password"].ToString().Trim(), DateTime.Parse(dt.Rows[0]["StartDate"].ToString()).ToString("yyyyMMddHHmm").Substring(2, 10), DateTime.Parse(dt.Rows[0]["EndDate"].ToString()).ToString("yyyyMMddHHmm").Substring(2, 10), "4");
AddLockLog(dt.Rows[0]["Password"].ToString(), "Freeze");
}
}
public void UpdateMonitorMotor(MonitorMotorInfo info)
{
string endDate = string.Empty;
if (info.EndDate.HasValue)
{
endDate = "'" + info.EndDate.ToString() + "'";
}
else
{
endDate = "null";
}
string sql = "update Rent_Motor_Monitor set MotorNO='" + info.MotorNO + "',StartDate='" + info.StartDate.ToString() + "',EndDate=" + endDate + ",MotorType='" + info.MotorType + "',Status='" + info.Status + "' where ID='" + info.ID + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}