public string CreateHomeLock(string address, string familyName, string userId, string city, string ownerName, string ownerMobile, string ownerId, string ownerAddress, string homeStatus)
{
if (!authentication.ValideLockUser())
{
return("{'headerError'}");
}
Dictionary <string, string> ret = new Dictionary <string, string>();
try
{
NewLockManager manager = new NewLockManager();
//传值校验
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("address", address);
dic.Add("familyName", familyName);
dic.Add("userId", userId);
dic.Add("city", city);
dic.Add("ownerName", ownerName);
dic.Add("ownerMobile", ownerMobile);
dic.Add("ownerId", ownerId);
dic.Add("ownerAddress", ownerAddress);
dic.Add("homeStatus", homeStatus);
string returnFiled = manager.checkIsNullFild(dic);
if (returnFiled != string.Empty)
{
ret.Add("ret", "1");
ret.Add("msg", "字段" + returnFiled + "不允许为空！");
return(JSONHelper.ToJson(ret));
}
if (manager.GetIsEnterprise(userId) == "2")
{
ret.Add("ret", "1");
ret.Add("msg", "我公司暂无给贵公司授权,请核对再操做！");
return(JSONHelper.ToJson(ret));
}
//判断接口是否授权
if (!manager.GetIsInterfacePermissions("1", userId))
{
ret.Add("ret", "1");
ret.Add("msg", "我公司暂无给贵公司授权该接口,请核对再操做！");
return(JSONHelper.ToJson(ret));
}
if (!manager.checkidcard(ownerId)) //身份证格式校验
{
ret.Add("ret", "1");
ret.Add("msg", "房主身份证号（ownerId）格式校验错误！");
return(JSONHelper.ToJson(ret));
}
if (!manager.IsTelephone(ownerMobile)) //手机号格式校验
{
ret.Add("ret", "1");
ret.Add("msg", "房主手机号格式（ownerMobile）校验错误！");
return(JSONHelper.ToJson(ret));
}
if (homeStatus != "1" && homeStatus != "2")
{
ret.Add("ret", "1");
ret.Add("msg", "homeStatus参数值超出允许范围！");
return(JSONHelper.ToJson(ret));
}
LogManager.WriteLog("Start......");
string deviceID = Guid.NewGuid().ToString("N");
string sql = string.Empty;
//请求远程创建家庭接口
string familyReturn = manager.createHomeInfo(deviceID);
LogManager.WriteLog("Start......" + familyReturn);
Dictionary <string, object> returnInfo = new Dictionary <string, object>();
returnInfo = JSONHelper.FromJson <Dictionary <string, object> >(familyReturn);
if (returnInfo["ret"].ToString() == "0")
{
string dateTime = DateTime.Now.ToString();
//信息记录
sql = "insert into Rent_NewLock_Process output inserted.NewLockId values('" + Guid.NewGuid().ToString() + "', '" + userId + "', '" + deviceID + "', '" + address + "', '','','true','','','','','" + dateTime + "','','" + familyName + "', '" + city + "')";
LogManager.WriteLog("SQL:" + sql);
DataTable dt = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
sql = "select * from Rent_NewLock_Process where NewLockID='" + dt.Rows[0]["NewLockID"].ToString() + "'";
LogManager.WriteLog("SQL:" + sql);
//锁房屋绑定
DataTable dtInfo = MySQLHelper.ExecuteDataset(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql)).Tables[0];
sql = "insert into Rent_Locks values('" + dtInfo.Rows[0]["DeviceID"].ToString() + "', 1, '0', 'NoConfiguration', '0', '" + dateTime + "', '0', '0', '" + dt.Rows[0]["NewLockID"].ToString() + "')";
LogManager.WriteLog("SQL:" + sql);
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
//家庭信息创建
sql = "insert into Enterprise_Homeowner_Info values('" + Guid.NewGuid().ToString() + "', '" + ownerName + "', '" + ownerMobile + "', '" + ownerId + "', '" + ownerAddress + "', '" + homeStatus + "', '" + userId + "', '" + dt.Rows[0]["NewLockID"].ToString() + "', '" + dateTime + "', '', '', '')";
LogManager.WriteLog("SQL:" + sql);
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
ret.Add("ret", "0");
ret.Add("msg", dt.Rows[0]["NewLockID"].ToString());
}
else
{
ret.Add("ret", "1");
ret.Add("msg", returnInfo["msg"].ToString());
}
}
catch (Exception ex)
{
ret.Add("ret", "1");
ret.Add("msg", ex.Message);
}
return(JSONHelper.ToJson(ret));
}