public DataTable GetAllMessages() { string sql = "select top 5 * from t_web_text order by wt_time desc "; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; return(dt); }
public DataTable GetStatisticTimeData(string category, string type, string year, string month, string day, string psName, string userId) { DataTable dataTable = null; SqlParameter[] parameters = { new SqlParameter("@statistictype", SqlDbType.VarChar, 50), new SqlParameter("@statisticyear", SqlDbType.VarChar, 50), new SqlParameter("@statisticmonth", SqlDbType.VarChar, 50), new SqlParameter("@statisticday", SqlDbType.VarChar, 50), new SqlParameter("@psname", SqlDbType.NVarChar, 50), new SqlParameter("@userId", SqlDbType.NVarChar, 50) }; parameters[0].Value = type; parameters[1].Value = year; parameters[2].Value = month; parameters[3].Value = day; parameters[4].Value = psName; parameters[5].Value = userId; if (!string.IsNullOrEmpty(category) || category == "0") { dataTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(CommandType.StoredProcedure, "up_RentReport_RentStatisticByPoliceStation", parameters)).Tables[0]; } else { dataTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(CommandType.StoredProcedure, "up_RentReport_RentHouseStatisticByPoliceStation", parameters)).Tables[0]; } return(dataTable); }
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 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 string GetRentNo(string RDID) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select LDShortName,LDName from Rent_District WITH (NOLOCK) where LDID='" + RDID + "'"); DataTable rentTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]; string ldName = rentTable.Rows[0]["LDName"].ToString(); string shortName = rentTable.Rows[0]["LDShortName"].ToString(); StringBuilder sqlStrId = new StringBuilder(); sqlStrId.Append("select top 1 substring(RentNo,charindex('-',RentNo)+1 ,len(RentNo)) as [LatestNo] from Rent_Rent where RDName='" + RDID + "' order by RID desc"); DataTable rentTable1 = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStrId.ToString())).Tables[0]; if (rentTable1 != null && rentTable1.Rows.Count > 0) { int maxRentNo = Convert.ToInt32(rentTable1.Rows[0]["LatestNo"]) + 1; return(shortName + "-" + maxRentNo.ToString()); } else { return(shortName + "-10000001"); } }
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 RentAttribute(int rraId) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("SELECT * FROM Rent_RentAttribute WHERE RRAID=@RRAID"); SqlParameter[] parameters = { new SqlParameter("@RRAID", SqlDbType.Int), }; parameters[0].Value = rraId; DataTable rentTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString(), parameters)).Tables[0]; if (rentTable != null && rentTable.Rows.Count > 0) { m_RRAID = Convert.ToInt16(rentTable.Rows[0]["RRAID"]); m_RentNo = rentTable.Rows[0]["RentNo"].ToString(); m_RRAContactName = rentTable.Rows[0]["RRAContactName"].ToString(); m_RRAContactTel = rentTable.Rows[0]["RRAContactTel"].ToString(); m_RRANationName = rentTable.Rows[0]["RRANationName"].ToString(); m_RRAIDCard = rentTable.Rows[0]["RRAIDCard"].ToString(); m_RRentPrice = Convert.ToDecimal(rentTable.Rows[0]["RRentPrice"]); m_RRAContactProvince = rentTable.Rows[0]["RRAContactProvince"].ToString(); m_RRAStartDate = DateTime.Parse(rentTable.Rows[0]["RRAStartDate"].ToString()); m_RRAEndDate = DateTime.Parse(rentTable.Rows[0]["RRAEndDate"].ToString()); if (!rentTable.Rows[0].IsNull("RRARealEndDate")) { m_RRARealEndDate = DateTime.Parse(rentTable.Rows[0]["RRARealEndDate"].ToString()); } RRACheckOutPerson = rentTable.Rows[0]["RRACheckOutPerson"].ToString(); RRACheckOutReason = rentTable.Rows[0]["RRACheckOutReason"].ToString(); m_RRADescription = rentTable.Rows[0]["RRADescription"].ToString(); m_RRACreatedBy = rentTable.Rows[0]["RRACreatedBy"].ToString(); m_RRACreatedDate = DateTime.Parse(rentTable.Rows[0]["RRACreatedDate"].ToString()); m_RRAModifiedBy = rentTable.Rows[0]["RRAModifiedBy"].ToString(); if (rentTable.Rows[0]["RRAStatus"] != null) { m_Status = rentTable.Rows[0]["RRAStatus"].ToString(); } if (rentTable.Rows[0]["RRAModifiedDate"] == null || string.IsNullOrEmpty(rentTable.Rows[0]["RRAModifiedDate"].ToString())) { m_RRAModifiedDate = null; } else { m_RRAModifiedDate = DateTime.Parse(rentTable.Rows[0]["RRAModifiedDate"].ToString()); } m_RRAIsActive = Convert.ToBoolean(rentTable.Rows[0]["RRAIsActive"].ToString()); } string sql = "select * from Rent_RentAttribute_External where RRAID=" + rraId; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; if (dt.Rows.Count > 0) { m_tenantId = dt.Rows[0]["HZTenantID"].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)); }
/// <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 DataTable GetRentAttribute(string id) { string sql = "select * from Rent_RentAttribute where RRAIsActive=0 and RRAID=" + id; DataSet ds = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)); return(ds.Tables[0]); }
public void DeleteRentAttribute(RentAttribute rentAttribute) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); strSql1.Append(" Update Rent_Rent set IsAvailable=0"); strSql1.Append(" where RentNo = '" + rentAttribute.RentNo + "'"); //Update strSql.Append(" Update Rent_RentAttribute set RRAIsActive=1, RRAStatus='5', "); strSql.Append(" RRAModifiedBy='" + rentAttribute.RRAModifiedBy + "',"); strSql.Append(" RRAModifiedDate='" + rentAttribute.RRAModifiedDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "'"); strSql.Append(" where RRAID = '" + rentAttribute.RRAID + "'"); SysLogHelper.AddLog(rentAttribute.RRAModifiedBy, "删除租赁信息ID:" + rentAttribute.RentNo, "删除-租赁信息"); List <SqlCommand> listSQL = new List <SqlCommand>(); listSQL.Add(MySQLHelper.CreateCommand(strSql.ToString())); listSQL.Add(MySQLHelper.CreateCommand(strSql1.ToString())); MySQLHelper.ExecuteNonQueryTrans(SqlConnString, listSQL); //清除密码和IC卡信息 ClearPasswordToLock(rentAttribute.RRAID.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())); }
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 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 DataTable GetUserRegRelationList(string userId) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from Rent_user_dept_relationship where t_wu_user_id=" + userId); return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]); }
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 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())); }
/// <summary> /// 添加密码到电子锁 /// </summary> /// <param name="rentNO"></param> /// <param name="pass"></param> /// <param name="startdate"></param> /// <param name="enddate"></param> /// <param name="phone"></param> /// <returns></returns> public string AddPassword(string rentNO, string pass, string startdate, string enddate, string phone) { Dictionary <string, string> ret = new Dictionary <string, string>(); string sql = "select * from Rent_Locks where rentNo='" + rentNO + "' and Status='0'"; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["DeviceType"].ToString() == "1") //新锁 { NewLockManager managerNew = new NewLockManager(); string r = managerNew.GetPostInterface(dt.Rows[0]["DeviceID"].ToString(), phone, "2", pass, startdate, enddate); //设置临时密码 ret = JSONHelper.FromJson <Dictionary <string, string> >(r); } else //旧锁 { LockManager manager = new LockManager(); manager.AddPassword(dt.Rows[0]["DeviceID"].ToString(), pass, startdate, enddate); string r = manager.UpdatePassengerInfoToDevice(dt.Rows[0]["DeviceID"].ToString(), "", "", "", pass, DateTime.Parse(startdate).ToString("yyyyMMddHHmm").Substring(2, 10), DateTime.Parse(enddate).ToString("yyyyMMddHHmm").Substring(2, 10), "3"); ret = JSONHelper.FromJson <Dictionary <string, string> >(r); } } else { ret.Add("ret", "1"); ret.Add("msg", "未发现智能锁信息,无法添加密码"); } 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())); }
/// <summary> /// 获取随行人员 /// </summary> /// <param name="rraId"></param> /// <returns></returns> public DataTable GetRetinues(string rraId) { string sql = "select * from Rent_Retinues where RRAID = '" + rraId + "'"; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; return(dt); }
public AttachmentInfo(int attachmentId) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from t_signet_attachment where sa_attachment_id=@attachmentId"); SqlParameter[] parameters = { new SqlParameter("@attachmentId", SqlDbType.BigInt), }; parameters[0].Value = attachmentId; DataTable attachmentTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString(), parameters)).Tables[0]; if (attachmentTable != null && attachmentTable.Rows.Count > 0) { m_attachmentId = attachmentId; m_signetId = attachmentTable.Rows[0]["sa_signet_id"].ToString(); m_attachmentTitle = attachmentTable.Rows[0]["sa_attachment_description"].ToString(); m_attachmentDemo = attachmentTable.Rows[0]["sa_attachment_demo"].ToString(); m_createDate = DateTime.Parse(attachmentTable.Rows[0]["sa_attachment_date"].ToString()); if (!attachmentTable.Rows[0].IsNull("sa_attachment_mark")) { m_fileInfo = (byte[])attachmentTable.Rows[0]["sa_attachment_mark"]; FileStream fileStream = new FileStream(System.Web.HttpContext.Current.Server.MapPath("~") + "\\temp_" + attachmentId.ToString() + ".jpg", FileMode.Create, FileAccess.ReadWrite); fileStream.Write(m_fileInfo, 0, m_fileInfo.Length); fileStream.Flush(); fileStream.Dispose(); } } }
//up_SignetInternet_RegDeptSelectAll public DataTable GetRegDeptList() { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from Rent_PoliceStation where parentID>0"); return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]); }
public bool IsExistsSameAddressRent(string rdName, string rsName, string rrName, string rDoor) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select 1 from Rent_Rent where RDName=@rdName AND RSName=@rsName AND RRName=@rrName and RDoor=@rDoor"); SqlParameter[] parameters = { new SqlParameter("@rdName", SqlDbType.NVarChar, 50), new SqlParameter("@rsName", SqlDbType.NVarChar, 50), new SqlParameter("@rrName", SqlDbType.NVarChar, 50), new SqlParameter("@rDoor", SqlDbType.NVarChar, 50), }; parameters[0].Value = rdName; parameters[1].Value = rsName; parameters[2].Value = rrName; parameters[3].Value = rDoor; DataTable rentTable = MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString(), parameters)).Tables[0]; if (rentTable != null && rentTable.Rows.Count > 0) { return(true); } else { return(false); } }
public DataTable GetDeptList() { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from CF_Department"); return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]); }
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 DataTable GetCummunityList() { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from Rent_Road"); return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]); }
public DataTable GetDataTable(string sql) { SqlParameter[] parameters = { }; return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sql, parameters)).Tables[0]); }
public DataTable GetCFUserList(string deptId) { StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select * from cf_user where DeptId=" + deptId); return(MySQLHelper.ExecuteDataset(SqlConnString, MySQLHelper.CreateCommand(sqlStr.ToString())).Tables[0]); }
public DataTable GetDeviceDetailInfo(string deviceId) { string sql = "select * from Rent_Locks where ID=" + deviceId; DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0]; return(dt); }
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); }