/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_userweixin GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,uId,wxName,wxId,yixinId,weixinCode,wxPwd,headerpic,apiurl,wxToken,wxProvince,wxCity,AppId,AppSecret,Access_Token,openIdStr,createDate,endDate,wenziMaxNum,tuwenMaxNum,yuyinMaxNum,wenziDefineNum,tuwenDefineNum,yuyinDefineNum,requestTTNum,requestUsedNum,smsTTNum,smsUsedNum,isDelete,deleteDate,wxType,remark,seq,extStr,extStr2,extStr3,extInt,extInt2 from wx_userweixin ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_userweixin model = new MxWeiXinPF.Model.wx_userweixin();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MxWeiXinPF.Model.wx_userweixin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into wx_userweixin(");
strSql.Append("uId,wxName,wxId,yixinId,weixinCode,wxPwd,headerpic,apiurl,wxToken,wxProvince,wxCity,AppId,AppSecret,Access_Token,openIdStr,createDate,endDate,wenziMaxNum,tuwenMaxNum,yuyinMaxNum,wenziDefineNum,tuwenDefineNum,yuyinDefineNum,requestTTNum,requestUsedNum,smsTTNum,smsUsedNum,isDelete,deleteDate,wxType,remark,seq,extStr,extStr2,extStr3,extInt,extInt2)");
strSql.Append(" values (");
strSql.Append("@uId,@wxName,@wxId,@yixinId,@weixinCode,@wxPwd,@headerpic,@apiurl,@wxToken,@wxProvince,@wxCity,@AppId,@AppSecret,@Access_Token,@openIdStr,@createDate,@endDate,@wenziMaxNum,@tuwenMaxNum,@yuyinMaxNum,@wenziDefineNum,@tuwenDefineNum,@yuyinDefineNum,@requestTTNum,@requestUsedNum,@smsTTNum,@smsUsedNum,@isDelete,@deleteDate,@wxType,@remark,@seq,@extStr,@extStr2,@extStr3,@extInt,@extInt2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@uId", SqlDbType.Int, 4),
new SqlParameter("@wxName", SqlDbType.VarChar, 200),
new SqlParameter("@wxId", SqlDbType.VarChar, 100),
new SqlParameter("@yixinId", SqlDbType.VarChar, 100),
new SqlParameter("@weixinCode", SqlDbType.VarChar, 100),
new SqlParameter("@wxPwd", SqlDbType.VarChar, 200),
new SqlParameter("@headerpic", SqlDbType.VarChar, 1000),
new SqlParameter("@apiurl", SqlDbType.VarChar, 1000),
new SqlParameter("@wxToken", SqlDbType.VarChar, 300),
new SqlParameter("@wxProvince", SqlDbType.VarChar, 200),
new SqlParameter("@wxCity", SqlDbType.VarChar, 200),
new SqlParameter("@AppId", SqlDbType.VarChar, 200),
new SqlParameter("@AppSecret", SqlDbType.VarChar, 200),
new SqlParameter("@Access_Token", SqlDbType.VarChar, 200),
new SqlParameter("@openIdStr", SqlDbType.Text),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@wenziMaxNum", SqlDbType.Int, 4),
new SqlParameter("@tuwenMaxNum", SqlDbType.Int, 4),
new SqlParameter("@yuyinMaxNum", SqlDbType.Int, 4),
new SqlParameter("@wenziDefineNum", SqlDbType.Int, 4),
new SqlParameter("@tuwenDefineNum", SqlDbType.Int, 4),
new SqlParameter("@yuyinDefineNum", SqlDbType.Int, 4),
new SqlParameter("@requestTTNum", SqlDbType.Int, 4),
new SqlParameter("@requestUsedNum", SqlDbType.Int, 4),
new SqlParameter("@smsTTNum", SqlDbType.Int, 4),
new SqlParameter("@smsUsedNum", SqlDbType.Int, 4),
new SqlParameter("@isDelete", SqlDbType.Bit, 1),
new SqlParameter("@deleteDate", SqlDbType.DateTime),
new SqlParameter("@wxType", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@seq", SqlDbType.Int, 4),
new SqlParameter("@extStr", SqlDbType.VarChar, 1000),
new SqlParameter("@extStr2", SqlDbType.VarChar, 1500),
new SqlParameter("@extStr3", SqlDbType.VarChar, 1000),
new SqlParameter("@extInt", SqlDbType.Int, 4),
new SqlParameter("@extInt2", SqlDbType.Int, 4)
};
parameters[0].Value = model.uId;
parameters[1].Value = model.wxName;
parameters[2].Value = model.wxId;
parameters[3].Value = model.yixinId;
parameters[4].Value = model.weixinCode;
parameters[5].Value = model.wxPwd;
parameters[6].Value = model.headerpic;
parameters[7].Value = model.apiurl;
parameters[8].Value = model.wxToken;
parameters[9].Value = model.wxProvince;
parameters[10].Value = model.wxCity;
parameters[11].Value = model.AppId;
parameters[12].Value = model.AppSecret;
parameters[13].Value = model.Access_Token;
parameters[14].Value = model.openIdStr;
parameters[15].Value = model.createDate;
parameters[16].Value = model.endDate;
parameters[17].Value = model.wenziMaxNum;
parameters[18].Value = model.tuwenMaxNum;
parameters[19].Value = model.yuyinMaxNum;
parameters[20].Value = model.wenziDefineNum;
parameters[21].Value = model.tuwenDefineNum;
parameters[22].Value = model.yuyinDefineNum;
parameters[23].Value = model.requestTTNum;
parameters[24].Value = model.requestUsedNum;
parameters[25].Value = model.smsTTNum;
parameters[26].Value = model.smsUsedNum;
parameters[27].Value = model.isDelete;
parameters[28].Value = model.deleteDate;
parameters[29].Value = model.wxType;
parameters[30].Value = model.remark;
parameters[31].Value = model.seq;
parameters[32].Value = model.extStr;
parameters[33].Value = model.extStr2;
parameters[34].Value = model.extStr3;
parameters[35].Value = model.extInt;
parameters[36].Value = model.extInt2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_userweixin DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_userweixin model = new MxWeiXinPF.Model.wx_userweixin();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["uId"] != null && row["uId"].ToString() != "")
{
model.uId = int.Parse(row["uId"].ToString());
}
if (row["wxName"] != null)
{
model.wxName = row["wxName"].ToString();
}
if (row["wxId"] != null)
{
model.wxId = row["wxId"].ToString();
}
if (row["yixinId"] != null)
{
model.yixinId = row["yixinId"].ToString();
}
if (row["weixinCode"] != null)
{
model.weixinCode = row["weixinCode"].ToString();
}
if (row["wxPwd"] != null)
{
model.wxPwd = row["wxPwd"].ToString();
}
if (row["headerpic"] != null)
{
model.headerpic = row["headerpic"].ToString();
}
if (row["apiurl"] != null)
{
model.apiurl = row["apiurl"].ToString();
}
if (row["wxToken"] != null)
{
model.wxToken = row["wxToken"].ToString();
}
if (row["wxProvince"] != null)
{
model.wxProvince = row["wxProvince"].ToString();
}
if (row["wxCity"] != null)
{
model.wxCity = row["wxCity"].ToString();
}
if (row["AppId"] != null)
{
model.AppId = row["AppId"].ToString();
}
if (row["AppSecret"] != null)
{
model.AppSecret = row["AppSecret"].ToString();
}
if (row["Access_Token"] != null)
{
model.Access_Token = row["Access_Token"].ToString();
}
if (row["openIdStr"] != null)
{
model.openIdStr = row["openIdStr"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["endDate"] != null && row["endDate"].ToString() != "")
{
model.endDate = DateTime.Parse(row["endDate"].ToString());
}
if (row["wenziMaxNum"] != null && row["wenziMaxNum"].ToString() != "")
{
model.wenziMaxNum = int.Parse(row["wenziMaxNum"].ToString());
}
if (row["tuwenMaxNum"] != null && row["tuwenMaxNum"].ToString() != "")
{
model.tuwenMaxNum = int.Parse(row["tuwenMaxNum"].ToString());
}
if (row["yuyinMaxNum"] != null && row["yuyinMaxNum"].ToString() != "")
{
model.yuyinMaxNum = int.Parse(row["yuyinMaxNum"].ToString());
}
if (row["wenziDefineNum"] != null && row["wenziDefineNum"].ToString() != "")
{
model.wenziDefineNum = int.Parse(row["wenziDefineNum"].ToString());
}
if (row["tuwenDefineNum"] != null && row["tuwenDefineNum"].ToString() != "")
{
model.tuwenDefineNum = int.Parse(row["tuwenDefineNum"].ToString());
}
if (row["yuyinDefineNum"] != null && row["yuyinDefineNum"].ToString() != "")
{
model.yuyinDefineNum = int.Parse(row["yuyinDefineNum"].ToString());
}
if (row["requestTTNum"] != null && row["requestTTNum"].ToString() != "")
{
model.requestTTNum = int.Parse(row["requestTTNum"].ToString());
}
if (row["requestUsedNum"] != null && row["requestUsedNum"].ToString() != "")
{
model.requestUsedNum = int.Parse(row["requestUsedNum"].ToString());
}
if (row["smsTTNum"] != null && row["smsTTNum"].ToString() != "")
{
model.smsTTNum = int.Parse(row["smsTTNum"].ToString());
}
if (row["smsUsedNum"] != null && row["smsUsedNum"].ToString() != "")
{
model.smsUsedNum = int.Parse(row["smsUsedNum"].ToString());
}
if (row["isDelete"] != null && row["isDelete"].ToString() != "")
{
if ((row["isDelete"].ToString() == "1") || (row["isDelete"].ToString().ToLower() == "true"))
{
model.isDelete = true;
}
else
{
model.isDelete = false;
}
}
if (row["deleteDate"] != null && row["deleteDate"].ToString() != "")
{
model.deleteDate = DateTime.Parse(row["deleteDate"].ToString());
}
if (row["wxType"] != null && row["wxType"].ToString() != "")
{
model.wxType = int.Parse(row["wxType"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["seq"] != null && row["seq"].ToString() != "")
{
model.seq = int.Parse(row["seq"].ToString());
}
if (row["extStr"] != null)
{
model.extStr = row["extStr"].ToString();
}
if (row["extStr2"] != null)
{
model.extStr2 = row["extStr2"].ToString();
}
if (row["extStr3"] != null)
{
model.extStr3 = row["extStr3"].ToString();
}
if (row["extInt"] != null && row["extInt"].ToString() != "")
{
model.extInt = int.Parse(row["extInt"].ToString());
}
if (row["extInt2"] != null && row["extInt2"].ToString() != "")
{
model.extInt2 = int.Parse(row["extInt2"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MxWeiXinPF.Model.wx_userweixin model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update wx_userweixin set ");
strSql.Append("uId=@uId,");
strSql.Append("wxName=@wxName,");
strSql.Append("wxId=@wxId,");
strSql.Append("yixinId=@yixinId,");
strSql.Append("weixinCode=@weixinCode,");
strSql.Append("wxPwd=@wxPwd,");
strSql.Append("headerpic=@headerpic,");
strSql.Append("apiurl=@apiurl,");
strSql.Append("wxToken=@wxToken,");
strSql.Append("wxProvince=@wxProvince,");
strSql.Append("wxCity=@wxCity,");
strSql.Append("AppId=@AppId,");
strSql.Append("AppSecret=@AppSecret,");
strSql.Append("Access_Token=@Access_Token,");
strSql.Append("openIdStr=@openIdStr,");
strSql.Append("createDate=@createDate,");
strSql.Append("endDate=@endDate,");
strSql.Append("wenziMaxNum=@wenziMaxNum,");
strSql.Append("tuwenMaxNum=@tuwenMaxNum,");
strSql.Append("yuyinMaxNum=@yuyinMaxNum,");
strSql.Append("wenziDefineNum=@wenziDefineNum,");
strSql.Append("tuwenDefineNum=@tuwenDefineNum,");
strSql.Append("yuyinDefineNum=@yuyinDefineNum,");
strSql.Append("requestTTNum=@requestTTNum,");
strSql.Append("requestUsedNum=@requestUsedNum,");
strSql.Append("smsTTNum=@smsTTNum,");
strSql.Append("smsUsedNum=@smsUsedNum,");
strSql.Append("isDelete=@isDelete,");
strSql.Append("deleteDate=@deleteDate,");
strSql.Append("wxType=@wxType,");
strSql.Append("remark=@remark,");
strSql.Append("seq=@seq,");
strSql.Append("extStr=@extStr,");
strSql.Append("extStr2=@extStr2,");
strSql.Append("extStr3=@extStr3,");
strSql.Append("extInt=@extInt,");
strSql.Append("extInt2=@extInt2");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@uId", SqlDbType.Int, 4),
new SqlParameter("@wxName", SqlDbType.VarChar, 200),
new SqlParameter("@wxId", SqlDbType.VarChar, 100),
new SqlParameter("@yixinId", SqlDbType.VarChar, 100),
new SqlParameter("@weixinCode", SqlDbType.VarChar, 100),
new SqlParameter("@wxPwd", SqlDbType.VarChar, 200),
new SqlParameter("@headerpic", SqlDbType.VarChar, 1000),
new SqlParameter("@apiurl", SqlDbType.VarChar, 1000),
new SqlParameter("@wxToken", SqlDbType.VarChar, 300),
new SqlParameter("@wxProvince", SqlDbType.VarChar, 200),
new SqlParameter("@wxCity", SqlDbType.VarChar, 200),
new SqlParameter("@AppId", SqlDbType.VarChar, 200),
new SqlParameter("@AppSecret", SqlDbType.VarChar, 200),
new SqlParameter("@Access_Token", SqlDbType.VarChar, 200),
new SqlParameter("@openIdStr", SqlDbType.Text),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@endDate", SqlDbType.DateTime),
new SqlParameter("@wenziMaxNum", SqlDbType.Int, 4),
new SqlParameter("@tuwenMaxNum", SqlDbType.Int, 4),
new SqlParameter("@yuyinMaxNum", SqlDbType.Int, 4),
new SqlParameter("@wenziDefineNum", SqlDbType.Int, 4),
new SqlParameter("@tuwenDefineNum", SqlDbType.Int, 4),
new SqlParameter("@yuyinDefineNum", SqlDbType.Int, 4),
new SqlParameter("@requestTTNum", SqlDbType.Int, 4),
new SqlParameter("@requestUsedNum", SqlDbType.Int, 4),
new SqlParameter("@smsTTNum", SqlDbType.Int, 4),
new SqlParameter("@smsUsedNum", SqlDbType.Int, 4),
new SqlParameter("@isDelete", SqlDbType.Bit, 1),
new SqlParameter("@deleteDate", SqlDbType.DateTime),
new SqlParameter("@wxType", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@seq", SqlDbType.Int, 4),
new SqlParameter("@extStr", SqlDbType.VarChar, 1000),
new SqlParameter("@extStr2", SqlDbType.VarChar, 1500),
new SqlParameter("@extStr3", SqlDbType.VarChar, 1000),
new SqlParameter("@extInt", SqlDbType.Int, 4),
new SqlParameter("@extInt2", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.uId;
parameters[1].Value = model.wxName;
parameters[2].Value = model.wxId;
parameters[3].Value = model.yixinId;
parameters[4].Value = model.weixinCode;
parameters[5].Value = model.wxPwd;
parameters[6].Value = model.headerpic;
parameters[7].Value = model.apiurl;
parameters[8].Value = model.wxToken;
parameters[9].Value = model.wxProvince;
parameters[10].Value = model.wxCity;
parameters[11].Value = model.AppId;
parameters[12].Value = model.AppSecret;
parameters[13].Value = model.Access_Token;
parameters[14].Value = model.openIdStr;
parameters[15].Value = model.createDate;
parameters[16].Value = model.endDate;
parameters[17].Value = model.wenziMaxNum;
parameters[18].Value = model.tuwenMaxNum;
parameters[19].Value = model.yuyinMaxNum;
parameters[20].Value = model.wenziDefineNum;
parameters[21].Value = model.tuwenDefineNum;
parameters[22].Value = model.yuyinDefineNum;
parameters[23].Value = model.requestTTNum;
parameters[24].Value = model.requestUsedNum;
parameters[25].Value = model.smsTTNum;
parameters[26].Value = model.smsUsedNum;
parameters[27].Value = model.isDelete;
parameters[28].Value = model.deleteDate;
parameters[29].Value = model.wxType;
parameters[30].Value = model.remark;
parameters[31].Value = model.seq;
parameters[32].Value = model.extStr;
parameters[33].Value = model.extStr2;
parameters[34].Value = model.extStr3;
parameters[35].Value = model.extInt;
parameters[36].Value = model.extInt2;
parameters[37].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_userweixin GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,uId,wxName,wxId,yixinId,weixinCode,wxPwd,headerpic,apiurl,wxToken,wxProvince,wxCity,AppId,AppSecret,Access_Token,openIdStr,createDate,endDate,wenziMaxNum,tuwenMaxNum,yuyinMaxNum,wenziDefineNum,tuwenDefineNum,yuyinDefineNum,requestTTNum,requestUsedNum,smsTTNum,smsUsedNum,isDelete,deleteDate,wxType,remark,seq,extStr,extStr2,extStr3,extInt,extInt2 from wx_userweixin ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_userweixin model=new MxWeiXinPF.Model.wx_userweixin();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_userweixin DataRowToModel(DataRow row)
{
MxWeiXinPF.Model.wx_userweixin model=new MxWeiXinPF.Model.wx_userweixin();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["uId"]!=null && row["uId"].ToString()!="")
{
model.uId=int.Parse(row["uId"].ToString());
}
if(row["wxName"]!=null)
{
model.wxName=row["wxName"].ToString();
}
if(row["wxId"]!=null)
{
model.wxId=row["wxId"].ToString();
}
if(row["yixinId"]!=null)
{
model.yixinId=row["yixinId"].ToString();
}
if(row["weixinCode"]!=null)
{
model.weixinCode=row["weixinCode"].ToString();
}
if(row["wxPwd"]!=null)
{
model.wxPwd=row["wxPwd"].ToString();
}
if(row["headerpic"]!=null)
{
model.headerpic=row["headerpic"].ToString();
}
if(row["apiurl"]!=null)
{
model.apiurl=row["apiurl"].ToString();
}
if(row["wxToken"]!=null)
{
model.wxToken=row["wxToken"].ToString();
}
if(row["wxProvince"]!=null)
{
model.wxProvince=row["wxProvince"].ToString();
}
if(row["wxCity"]!=null)
{
model.wxCity=row["wxCity"].ToString();
}
if(row["AppId"]!=null)
{
model.AppId=row["AppId"].ToString();
}
if(row["AppSecret"]!=null)
{
model.AppSecret=row["AppSecret"].ToString();
}
if(row["Access_Token"]!=null)
{
model.Access_Token=row["Access_Token"].ToString();
}
if(row["openIdStr"]!=null)
{
model.openIdStr=row["openIdStr"].ToString();
}
if(row["createDate"]!=null && row["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(row["createDate"].ToString());
}
if(row["endDate"]!=null && row["endDate"].ToString()!="")
{
model.endDate=DateTime.Parse(row["endDate"].ToString());
}
if(row["wenziMaxNum"]!=null && row["wenziMaxNum"].ToString()!="")
{
model.wenziMaxNum=int.Parse(row["wenziMaxNum"].ToString());
}
if(row["tuwenMaxNum"]!=null && row["tuwenMaxNum"].ToString()!="")
{
model.tuwenMaxNum=int.Parse(row["tuwenMaxNum"].ToString());
}
if(row["yuyinMaxNum"]!=null && row["yuyinMaxNum"].ToString()!="")
{
model.yuyinMaxNum=int.Parse(row["yuyinMaxNum"].ToString());
}
if(row["wenziDefineNum"]!=null && row["wenziDefineNum"].ToString()!="")
{
model.wenziDefineNum=int.Parse(row["wenziDefineNum"].ToString());
}
if(row["tuwenDefineNum"]!=null && row["tuwenDefineNum"].ToString()!="")
{
model.tuwenDefineNum=int.Parse(row["tuwenDefineNum"].ToString());
}
if(row["yuyinDefineNum"]!=null && row["yuyinDefineNum"].ToString()!="")
{
model.yuyinDefineNum=int.Parse(row["yuyinDefineNum"].ToString());
}
if(row["requestTTNum"]!=null && row["requestTTNum"].ToString()!="")
{
model.requestTTNum=int.Parse(row["requestTTNum"].ToString());
}
if(row["requestUsedNum"]!=null && row["requestUsedNum"].ToString()!="")
{
model.requestUsedNum=int.Parse(row["requestUsedNum"].ToString());
}
if(row["smsTTNum"]!=null && row["smsTTNum"].ToString()!="")
{
model.smsTTNum=int.Parse(row["smsTTNum"].ToString());
}
if(row["smsUsedNum"]!=null && row["smsUsedNum"].ToString()!="")
{
model.smsUsedNum=int.Parse(row["smsUsedNum"].ToString());
}
if(row["isDelete"]!=null && row["isDelete"].ToString()!="")
{
if((row["isDelete"].ToString()=="1")||(row["isDelete"].ToString().ToLower()=="true"))
{
model.isDelete=true;
}
else
{
model.isDelete=false;
}
}
if(row["deleteDate"]!=null && row["deleteDate"].ToString()!="")
{
model.deleteDate=DateTime.Parse(row["deleteDate"].ToString());
}
if(row["wxType"]!=null && row["wxType"].ToString()!="")
{
model.wxType=int.Parse(row["wxType"].ToString());
}
if(row["remark"]!=null)
{
model.remark=row["remark"].ToString();
}
if(row["seq"]!=null && row["seq"].ToString()!="")
{
model.seq=int.Parse(row["seq"].ToString());
}
if(row["extStr"]!=null)
{
model.extStr=row["extStr"].ToString();
}
if(row["extStr2"]!=null)
{
model.extStr2=row["extStr2"].ToString();
}
if(row["extStr3"]!=null)
{
model.extStr3=row["extStr3"].ToString();
}
if(row["extInt"]!=null && row["extInt"].ToString()!="")
{
model.extInt=int.Parse(row["extInt"].ToString());
}
if(row["extInt2"]!=null && row["extInt2"].ToString()!="")
{
model.extInt2=int.Parse(row["extInt2"].ToString());
}
}
return model;
}
/// <summary>
/// 得到微信配置信息（使用SqlDataReader）
/// </summary>
/// <param name="rid">规则主键Id</param>
/// <returns></returns>
public Model.wx_userweixin GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from wx_userweixin ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
SqlDataReader sr = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
MxWeiXinPF.Model.wx_userweixin model = model = new MxWeiXinPF.Model.wx_userweixin();
while (sr.Read())
{
#region while循环
model.id = int.Parse(sr["id"].ToString());
if (sr["uId"] != null && sr["uId"].ToString() != "")
{
model.uId = int.Parse(sr["uId"].ToString());
}
if (sr["wxName"] != null)
{
model.wxName = sr["wxName"].ToString();
}
if (sr["wxId"] != null)
{
model.wxId = sr["wxId"].ToString();
}
if (sr["yixinId"] != null)
{
model.yixinId = sr["yixinId"].ToString();
}
if (sr["weixinCode"] != null)
{
model.weixinCode = sr["weixinCode"].ToString();
}
if (sr["wxPwd"] != null)
{
model.wxPwd = sr["wxPwd"].ToString();
}
if (sr["headerpic"] != null)
{
model.headerpic = sr["headerpic"].ToString();
}
if (sr["apiurl"] != null)
{
model.apiurl = sr["apiurl"].ToString();
}
if (sr["wxToken"] != null)
{
model.wxToken = sr["wxToken"].ToString();
}
if (sr["wxProvince"] != null)
{
model.wxProvince = sr["wxProvince"].ToString();
}
if (sr["wxCity"] != null)
{
model.wxCity = sr["wxCity"].ToString();
}
if (sr["AppId"] != null)
{
model.AppId = sr["AppId"].ToString();
}
else
{
model.AppId = "";
}
if (sr["AppSecret"] != null)
{
model.AppSecret = sr["AppSecret"].ToString();
}
if (sr["Access_Token"] != null)
{
model.Access_Token = sr["Access_Token"].ToString();
}
if (sr["openIdStr"] != null)
{
model.openIdStr = sr["openIdStr"].ToString();
}
if (sr["createDate"] != null && sr["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(sr["createDate"].ToString());
}
if (sr["endDate"] != null && sr["endDate"].ToString() != "")
{
model.endDate = DateTime.Parse(sr["endDate"].ToString());
}
if (sr["wenziMaxNum"] != null && sr["wenziMaxNum"].ToString() != "")
{
model.wenziMaxNum = int.Parse(sr["wenziMaxNum"].ToString());
}
if (sr["tuwenMaxNum"] != null && sr["tuwenMaxNum"].ToString() != "")
{
model.tuwenMaxNum = int.Parse(sr["tuwenMaxNum"].ToString());
}
if (sr["yuyinMaxNum"] != null && sr["yuyinMaxNum"].ToString() != "")
{
model.yuyinMaxNum = int.Parse(sr["yuyinMaxNum"].ToString());
}
if (sr["wenziDefineNum"] != null && sr["wenziDefineNum"].ToString() != "")
{
model.wenziDefineNum = int.Parse(sr["wenziDefineNum"].ToString());
}
if (sr["tuwenDefineNum"] != null && sr["tuwenDefineNum"].ToString() != "")
{
model.tuwenDefineNum = int.Parse(sr["tuwenDefineNum"].ToString());
}
if (sr["yuyinDefineNum"] != null && sr["yuyinDefineNum"].ToString() != "")
{
model.yuyinDefineNum = int.Parse(sr["yuyinDefineNum"].ToString());
}
if (sr["requestTTNum"] != null && sr["requestTTNum"].ToString() != "")
{
model.requestTTNum = int.Parse(sr["requestTTNum"].ToString());
}
if (sr["requestUsedNum"] != null && sr["requestUsedNum"].ToString() != "")
{
model.requestUsedNum = int.Parse(sr["requestUsedNum"].ToString());
}
if (sr["smsTTNum"] != null && sr["smsTTNum"].ToString() != "")
{
model.smsTTNum = int.Parse(sr["smsTTNum"].ToString());
}
if (sr["smsUsedNum"] != null && sr["smsUsedNum"].ToString() != "")
{
model.smsUsedNum = int.Parse(sr["smsUsedNum"].ToString());
}
if (sr["isDelete"] != null && sr["isDelete"].ToString() != "")
{
if ((sr["isDelete"].ToString() == "1") || (sr["isDelete"].ToString().ToLower() == "true"))
{
model.isDelete = true;
}
else
{
model.isDelete = false;
}
}
if (sr["deleteDate"] != null && sr["deleteDate"].ToString() != "")
{
model.deleteDate = DateTime.Parse(sr["deleteDate"].ToString());
}
if (sr["wxType"] != null && sr["wxType"].ToString() != "")
{
model.wxType = int.Parse(sr["wxType"].ToString());
}
if (sr["remark"] != null)
{
model.remark = sr["remark"].ToString();
}
if (sr["seq"] != null && sr["seq"].ToString() != "")
{
model.seq = int.Parse(sr["seq"].ToString());
}
if (sr["extStr"] != null)
{
model.extStr = sr["extStr"].ToString();
}
else
{
model.extStr = "";
}
if (sr["extStr2"] != null)
{
model.extStr2 = sr["extStr2"].ToString();
}
if (sr["extStr3"] != null)
{
model.extStr3 = sr["extStr3"].ToString();
}
if (sr["extInt"] != null && sr["extInt"].ToString() != "")
{
model.extInt = int.Parse(sr["extInt"].ToString());
}
if (sr["extInt2"] != null && sr["extInt2"].ToString() != "")
{
model.extInt2 = int.Parse(sr["extInt2"].ToString());
}
if (sr["wStatus"] != null && sr["wStatus"].ToString() != "")
{
model.wStatus = int.Parse(sr["wStatus"].ToString());
}
if (sr["closeKW"] != null && sr["closeKW"].ToString() != "")
{
if ((sr["closeKW"].ToString() == "1") || (sr["closeKW"].ToString().ToLower() == "true"))
{
model.closeKW = true;
}
else
{
model.closeKW = false;
}
}
#endregion
}
sr.Close();
if (model != null && model.id > 0)
{
return(model);
}
else
{
return(null);
}
}