/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.SYS_AdminUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SYS_AdminUser("); strSql.Append("Dpt_Id,Adn_UserName,Adn_Password,Adn_Mobile,Adn_AddTime,Adn_Flag,Adn_RealName,Adn_SecurityID,Adn_IsWorker,Adn_SelfCard,OpenId,Adn_IsConsultant,Wx_FakeId,Wx_NickName,Wx_ReMarkName,Wx_Username,Wx_Signature,Wx_Country,Wx_Province,Wx_City,Wx_Sex,Wx_GroupID,Wx_GroupName,Wx_UserImage,Wx_Status,Wx_MsgId,Wx_MsgCreateDateTime,Wx_MsgContent)"); strSql.Append(" values ("); strSql.Append("@Dpt_Id,@Adn_UserName,@Adn_Password,@Adn_Mobile,@Adn_AddTime,@Adn_Flag,@Adn_RealName,@Adn_SecurityID,@Adn_IsWorker,@Adn_SelfCard,@OpenId,@Adn_IsConsultant,@Wx_FakeId,@Wx_NickName,@Wx_ReMarkName,@Wx_Username,@Wx_Signature,@Wx_Country,@Wx_Province,@Wx_City,@Wx_Sex,@Wx_GroupID,@Wx_GroupName,@Wx_UserImage,@Wx_Status,@Wx_MsgId,@Wx_MsgCreateDateTime,@Wx_MsgContent)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Dpt_Id", DbType.Int32, model.Dpt_Id); db.AddInParameter(dbCommand, "Adn_UserName", DbType.AnsiString, model.Adn_UserName); db.AddInParameter(dbCommand, "Adn_Password", DbType.AnsiString, model.Adn_Password); db.AddInParameter(dbCommand, "Adn_Mobile", DbType.AnsiString, model.Adn_Mobile); db.AddInParameter(dbCommand, "Adn_AddTime", DbType.DateTime, model.Adn_AddTime); db.AddInParameter(dbCommand, "Adn_Flag", DbType.Int32, model.Adn_Flag); db.AddInParameter(dbCommand, "Adn_RealName", DbType.String, model.Adn_RealName); db.AddInParameter(dbCommand, "Adn_SecurityID", DbType.AnsiString, model.Adn_SecurityID); db.AddInParameter(dbCommand, "Adn_IsWorker", DbType.Byte, model.Adn_IsWorker); db.AddInParameter(dbCommand, "Adn_SelfCard", DbType.AnsiString, model.Adn_SelfCard); db.AddInParameter(dbCommand, "OpenId", DbType.AnsiString, model.OpenId); db.AddInParameter(dbCommand, "Adn_IsConsultant", DbType.Int32, model.Adn_IsConsultant); db.AddInParameter(dbCommand, "Wx_FakeId", DbType.String, model.Wx_FakeId); db.AddInParameter(dbCommand, "Wx_NickName", DbType.String, model.Wx_NickName); db.AddInParameter(dbCommand, "Wx_ReMarkName", DbType.String, model.Wx_ReMarkName); db.AddInParameter(dbCommand, "Wx_Username", DbType.String, model.Wx_Username); db.AddInParameter(dbCommand, "Wx_Signature", DbType.String, model.Wx_Signature); db.AddInParameter(dbCommand, "Wx_Country", DbType.String, model.Wx_Country); db.AddInParameter(dbCommand, "Wx_Province", DbType.String, model.Wx_Province); db.AddInParameter(dbCommand, "Wx_City", DbType.String, model.Wx_City); db.AddInParameter(dbCommand, "Wx_Sex", DbType.Byte, model.Wx_Sex); db.AddInParameter(dbCommand, "Wx_GroupID", DbType.Int32, model.Wx_GroupID); db.AddInParameter(dbCommand, "Wx_GroupName", DbType.String, model.Wx_GroupName); db.AddInParameter(dbCommand, "Wx_UserImage", DbType.String, model.Wx_UserImage); db.AddInParameter(dbCommand, "Wx_Status", DbType.Byte, model.Wx_Status); db.AddInParameter(dbCommand, "Wx_MsgId", DbType.Int64, model.Wx_MsgId); db.AddInParameter(dbCommand, "Wx_MsgCreateDateTime", DbType.DateTime, model.Wx_MsgCreateDateTime); db.AddInParameter(dbCommand, "Wx_MsgContent", DbType.String, model.Wx_MsgContent); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 根据openId获取user /// </summary> /// <param name="openId"></param> /// <returns></returns> public Model.SYS_AdminUser GetModel(string openId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from SYS_AdminUser "); strSql.Append(" where openId=@openId "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "openId", DbType.String, openId); Model.SYS_AdminUser model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_AdminUser GetModel(int Adn_Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Adn_Id,Dpt_Id,Adn_UserName,Adn_Password,Adn_Mobile,Adn_AddTime,Adn_Flag,Adn_RealName,Adn_SecurityID,Adn_IsWorker,Adn_SelfCard,OpenId,Adn_IsConsultant,Wx_FakeId,Wx_NickName,Wx_ReMarkName,Wx_Username,Wx_Signature,Wx_Country,Wx_Province,Wx_City,Wx_Sex,Wx_GroupID,Wx_GroupName,Wx_UserImage,Wx_Status,Wx_MsgId,Wx_MsgCreateDateTime,Wx_MsgContent from SYS_AdminUser "); strSql.Append(" where Adn_Id=@Adn_Id "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Adn_Id", DbType.Int32, Adn_Id); Model.SYS_AdminUser model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_AdminUser DataRowToModel(DataRow row) { Model.SYS_AdminUser model = new Model.SYS_AdminUser(); if (row != null) { if (row["Adn_Id"] != null && row["Adn_Id"].ToString() != "") { model.Adn_Id = int.Parse(row["Adn_Id"].ToString()); } if (row["Dpt_Id"] != null && row["Dpt_Id"].ToString() != "") { model.Dpt_Id = int.Parse(row["Dpt_Id"].ToString()); } if (row["Adn_UserName"] != null) { model.Adn_UserName = row["Adn_UserName"].ToString(); } if (row["Adn_Password"] != null) { model.Adn_Password = row["Adn_Password"].ToString(); } if (row["Adn_Mobile"] != null) { model.Adn_Mobile = row["Adn_Mobile"].ToString(); } if (row["Adn_AddTime"] != null && row["Adn_AddTime"].ToString() != "") { model.Adn_AddTime = DateTime.Parse(row["Adn_AddTime"].ToString()); } if (row["Adn_Flag"] != null && row["Adn_Flag"].ToString() != "") { model.Adn_Flag = int.Parse(row["Adn_Flag"].ToString()); } if (row["Adn_RealName"] != null) { model.Adn_RealName = row["Adn_RealName"].ToString(); } if (row["Adn_SecurityID"] != null) { model.Adn_SecurityID = row["Adn_SecurityID"].ToString(); } if (row["Adn_IsWorker"] != null && row["Adn_IsWorker"].ToString() != "") { model.Adn_IsWorker = int.Parse(row["Adn_IsWorker"].ToString()); } if (row["Adn_SelfCard"] != null) { model.Adn_SelfCard = row["Adn_SelfCard"].ToString(); } if (row["OpenId"] != null) { model.OpenId = row["OpenId"].ToString(); } if (row["Adn_IsConsultant"] != null && row["Adn_IsConsultant"].ToString() != "") { model.Adn_IsConsultant = int.Parse(row["Adn_IsConsultant"].ToString()); } if (row["Wx_FakeId"] != null) { model.Wx_FakeId = row["Wx_FakeId"].ToString(); } if (row["Wx_NickName"] != null) { model.Wx_NickName = row["Wx_NickName"].ToString(); } if (row["Wx_ReMarkName"] != null) { model.Wx_ReMarkName = row["Wx_ReMarkName"].ToString(); } if (row["Wx_Username"] != null) { model.Wx_Username = row["Wx_Username"].ToString(); } if (row["Wx_Signature"] != null) { model.Wx_Signature = row["Wx_Signature"].ToString(); } if (row["Wx_Country"] != null) { model.Wx_Country = row["Wx_Country"].ToString(); } if (row["Wx_Province"] != null) { model.Wx_Province = row["Wx_Province"].ToString(); } if (row["Wx_City"] != null) { model.Wx_City = row["Wx_City"].ToString(); } if (row["Wx_Sex"] != null && row["Wx_Sex"].ToString() != "") { model.Wx_Sex = int.Parse(row["Wx_Sex"].ToString()); } if (row["Wx_GroupID"] != null && row["Wx_GroupID"].ToString() != "") { model.Wx_GroupID = int.Parse(row["Wx_GroupID"].ToString()); } if (row["Wx_GroupName"] != null) { model.Wx_GroupName = row["Wx_GroupName"].ToString(); } if (row["Wx_UserImage"] != null) { model.Wx_UserImage = row["Wx_UserImage"].ToString(); } if (row["Wx_Status"] != null && row["Wx_Status"].ToString() != "") { model.Wx_Status = int.Parse(row["Wx_Status"].ToString()); } if (row["Wx_MsgId"] != null && row["Wx_MsgId"].ToString() != "") { model.Wx_MsgId = long.Parse(row["Wx_MsgId"].ToString()); } if (row["Wx_MsgCreateDateTime"] != null && row["Wx_MsgCreateDateTime"].ToString() != "") { model.Wx_MsgCreateDateTime = DateTime.Parse(row["Wx_MsgCreateDateTime"].ToString()); } if (row["Wx_MsgContent"] != null) { model.Wx_MsgContent = row["Wx_MsgContent"].ToString(); } } return model; }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.SYS_AdminUser ReaderBind(IDataReader dataReader) { Model.SYS_AdminUser model = new Model.SYS_AdminUser(); object ojb; ojb = dataReader["Adn_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_Id = Convert.ToInt32(ojb); } ojb = dataReader["Dpt_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Dpt_Id = Convert.ToInt32(ojb); } model.Adn_UserName = dataReader["Adn_UserName"].ToString(); model.Adn_Password = dataReader["Adn_Password"].ToString(); model.Adn_Mobile = dataReader["Adn_Mobile"].ToString(); ojb = dataReader["Adn_AddTime"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_AddTime = (DateTime)ojb; } ojb = dataReader["Adn_Flag"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_Flag = Convert.ToInt32(ojb); } model.Adn_RealName = dataReader["Adn_RealName"].ToString(); model.Adn_SecurityID = dataReader["Adn_SecurityID"].ToString(); ojb = dataReader["Adn_IsWorker"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_IsWorker = Convert.ToInt32(ojb); } model.Adn_SelfCard = dataReader["Adn_SelfCard"].ToString(); model.OpenId = dataReader["OpenId"].ToString(); ojb = dataReader["Adn_IsConsultant"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_IsConsultant = Convert.ToInt32(ojb); } model.Wx_FakeId = dataReader["Wx_FakeId"].ToString(); model.Wx_NickName = dataReader["Wx_NickName"].ToString(); model.Wx_ReMarkName = dataReader["Wx_ReMarkName"].ToString(); model.Wx_Username = dataReader["Wx_Username"].ToString(); model.Wx_Signature = dataReader["Wx_Signature"].ToString(); model.Wx_Country = dataReader["Wx_Country"].ToString(); model.Wx_Province = dataReader["Wx_Province"].ToString(); model.Wx_City = dataReader["Wx_City"].ToString(); ojb = dataReader["Wx_Sex"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_Sex = Convert.ToInt32(ojb); } ojb = dataReader["Wx_GroupID"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_GroupID = Convert.ToInt32(ojb); } model.Wx_GroupName = dataReader["Wx_GroupName"].ToString(); model.Wx_UserImage = dataReader["Wx_UserImage"].ToString(); ojb = dataReader["Wx_Status"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_Status = Convert.ToInt32(ojb); } ojb = dataReader["Wx_MsgId"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_MsgId = Convert.ToInt64(ojb); } ojb = dataReader["Wx_MsgCreateDateTime"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_MsgCreateDateTime = (DateTime)ojb; } model.Wx_MsgContent = dataReader["Wx_MsgContent"].ToString(); return model; }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.SYS_AdminUser ReaderBind(IDataReader dataReader) { Model.SYS_AdminUser model = new Model.SYS_AdminUser(); object ojb; ojb = dataReader["Adn_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_Id = Convert.ToInt32(ojb); } ojb = dataReader["Dpt_Id"]; if (ojb != null && ojb != DBNull.Value) { model.Dpt_Id = Convert.ToInt32(ojb); } model.Adn_UserName = dataReader["Adn_UserName"].ToString(); model.Adn_Password = dataReader["Adn_Password"].ToString(); model.Adn_Mobile = dataReader["Adn_Mobile"].ToString(); ojb = dataReader["Adn_AddTime"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_AddTime = (DateTime)ojb; } ojb = dataReader["Adn_Flag"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_Flag = Convert.ToInt32(ojb); } model.Adn_RealName = dataReader["Adn_RealName"].ToString(); model.Adn_SecurityID = dataReader["Adn_SecurityID"].ToString(); ojb = dataReader["Adn_IsWorker"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_IsWorker = Convert.ToInt32(ojb); } model.Adn_SelfCard = dataReader["Adn_SelfCard"].ToString(); model.OpenId = dataReader["OpenId"].ToString(); ojb = dataReader["Adn_IsConsultant"]; if (ojb != null && ojb != DBNull.Value) { model.Adn_IsConsultant = Convert.ToInt32(ojb); } model.Wx_FakeId = dataReader["Wx_FakeId"].ToString(); model.Wx_NickName = dataReader["Wx_NickName"].ToString(); model.Wx_ReMarkName = dataReader["Wx_ReMarkName"].ToString(); model.Wx_Username = dataReader["Wx_Username"].ToString(); model.Wx_Signature = dataReader["Wx_Signature"].ToString(); model.Wx_Country = dataReader["Wx_Country"].ToString(); model.Wx_Province = dataReader["Wx_Province"].ToString(); model.Wx_City = dataReader["Wx_City"].ToString(); ojb = dataReader["Wx_Sex"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_Sex = Convert.ToInt32(ojb); } ojb = dataReader["Wx_GroupID"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_GroupID = Convert.ToInt32(ojb); } model.Wx_GroupName = dataReader["Wx_GroupName"].ToString(); model.Wx_UserImage = dataReader["Wx_UserImage"].ToString(); ojb = dataReader["Wx_Status"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_Status = Convert.ToInt32(ojb); } ojb = dataReader["Wx_MsgId"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_MsgId = Convert.ToInt64(ojb); } ojb = dataReader["Wx_MsgCreateDateTime"]; if (ojb != null && ojb != DBNull.Value) { model.Wx_MsgCreateDateTime = (DateTime)ojb; } model.Wx_MsgContent = dataReader["Wx_MsgContent"].ToString(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_AdminUser DataRowToModel(DataRow row) { Model.SYS_AdminUser model = new Model.SYS_AdminUser(); if (row != null) { if (row["Adn_Id"] != null && row["Adn_Id"].ToString() != "") { model.Adn_Id = int.Parse(row["Adn_Id"].ToString()); } if (row["Dpt_Id"] != null && row["Dpt_Id"].ToString() != "") { model.Dpt_Id = int.Parse(row["Dpt_Id"].ToString()); } if (row["Adn_UserName"] != null) { model.Adn_UserName = row["Adn_UserName"].ToString(); } if (row["Adn_Password"] != null) { model.Adn_Password = row["Adn_Password"].ToString(); } if (row["Adn_Mobile"] != null) { model.Adn_Mobile = row["Adn_Mobile"].ToString(); } if (row["Adn_AddTime"] != null && row["Adn_AddTime"].ToString() != "") { model.Adn_AddTime = DateTime.Parse(row["Adn_AddTime"].ToString()); } if (row["Adn_Flag"] != null && row["Adn_Flag"].ToString() != "") { model.Adn_Flag = int.Parse(row["Adn_Flag"].ToString()); } if (row["Adn_RealName"] != null) { model.Adn_RealName = row["Adn_RealName"].ToString(); } if (row["Adn_SecurityID"] != null) { model.Adn_SecurityID = row["Adn_SecurityID"].ToString(); } if (row["Adn_IsWorker"] != null && row["Adn_IsWorker"].ToString() != "") { model.Adn_IsWorker = int.Parse(row["Adn_IsWorker"].ToString()); } if (row["Adn_SelfCard"] != null) { model.Adn_SelfCard = row["Adn_SelfCard"].ToString(); } if (row["OpenId"] != null) { model.OpenId = row["OpenId"].ToString(); } if (row["Adn_IsConsultant"] != null && row["Adn_IsConsultant"].ToString() != "") { model.Adn_IsConsultant = int.Parse(row["Adn_IsConsultant"].ToString()); } if (row["Wx_FakeId"] != null) { model.Wx_FakeId = row["Wx_FakeId"].ToString(); } if (row["Wx_NickName"] != null) { model.Wx_NickName = row["Wx_NickName"].ToString(); } if (row["Wx_ReMarkName"] != null) { model.Wx_ReMarkName = row["Wx_ReMarkName"].ToString(); } if (row["Wx_Username"] != null) { model.Wx_Username = row["Wx_Username"].ToString(); } if (row["Wx_Signature"] != null) { model.Wx_Signature = row["Wx_Signature"].ToString(); } if (row["Wx_Country"] != null) { model.Wx_Country = row["Wx_Country"].ToString(); } if (row["Wx_Province"] != null) { model.Wx_Province = row["Wx_Province"].ToString(); } if (row["Wx_City"] != null) { model.Wx_City = row["Wx_City"].ToString(); } if (row["Wx_Sex"] != null && row["Wx_Sex"].ToString() != "") { model.Wx_Sex = int.Parse(row["Wx_Sex"].ToString()); } if (row["Wx_GroupID"] != null && row["Wx_GroupID"].ToString() != "") { model.Wx_GroupID = int.Parse(row["Wx_GroupID"].ToString()); } if (row["Wx_GroupName"] != null) { model.Wx_GroupName = row["Wx_GroupName"].ToString(); } if (row["Wx_UserImage"] != null) { model.Wx_UserImage = row["Wx_UserImage"].ToString(); } if (row["Wx_Status"] != null && row["Wx_Status"].ToString() != "") { model.Wx_Status = int.Parse(row["Wx_Status"].ToString()); } if (row["Wx_MsgId"] != null && row["Wx_MsgId"].ToString() != "") { model.Wx_MsgId = long.Parse(row["Wx_MsgId"].ToString()); } if (row["Wx_MsgCreateDateTime"] != null && row["Wx_MsgCreateDateTime"].ToString() != "") { model.Wx_MsgCreateDateTime = DateTime.Parse(row["Wx_MsgCreateDateTime"].ToString()); } if (row["Wx_MsgContent"] != null) { model.Wx_MsgContent = row["Wx_MsgContent"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.SYS_AdminUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SYS_AdminUser set "); strSql.Append("Dpt_Id=@Dpt_Id,"); strSql.Append("Adn_UserName=@Adn_UserName,"); strSql.Append("Adn_Password=@Adn_Password,"); strSql.Append("Adn_Mobile=@Adn_Mobile,"); strSql.Append("Adn_AddTime=@Adn_AddTime,"); strSql.Append("Adn_Flag=@Adn_Flag,"); strSql.Append("Adn_RealName=@Adn_RealName,"); strSql.Append("Adn_SecurityID=@Adn_SecurityID,"); strSql.Append("Adn_IsWorker=@Adn_IsWorker,"); strSql.Append("Adn_SelfCard=@Adn_SelfCard,"); strSql.Append("OpenId=@OpenId,"); strSql.Append("Adn_IsConsultant=@Adn_IsConsultant,"); strSql.Append("Wx_FakeId=@Wx_FakeId,"); strSql.Append("Wx_NickName=@Wx_NickName,"); strSql.Append("Wx_ReMarkName=@Wx_ReMarkName,"); strSql.Append("Wx_Username=@Wx_Username,"); strSql.Append("Wx_Signature=@Wx_Signature,"); strSql.Append("Wx_Country=@Wx_Country,"); strSql.Append("Wx_Province=@Wx_Province,"); strSql.Append("Wx_City=@Wx_City,"); strSql.Append("Wx_Sex=@Wx_Sex,"); strSql.Append("Wx_GroupID=@Wx_GroupID,"); strSql.Append("Wx_GroupName=@Wx_GroupName,"); strSql.Append("Wx_UserImage=@Wx_UserImage,"); strSql.Append("Wx_Status=@Wx_Status,"); strSql.Append("Wx_MsgId=@Wx_MsgId,"); strSql.Append("Wx_MsgCreateDateTime=@Wx_MsgCreateDateTime,"); strSql.Append("Wx_MsgContent=@Wx_MsgContent"); strSql.Append(" where Adn_Id=@Adn_Id "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Adn_Id", DbType.Int32, model.Adn_Id); db.AddInParameter(dbCommand, "Dpt_Id", DbType.Int32, model.Dpt_Id); db.AddInParameter(dbCommand, "Adn_UserName", DbType.AnsiString, model.Adn_UserName); db.AddInParameter(dbCommand, "Adn_Password", DbType.AnsiString, model.Adn_Password); db.AddInParameter(dbCommand, "Adn_Mobile", DbType.AnsiString, model.Adn_Mobile); db.AddInParameter(dbCommand, "Adn_AddTime", DbType.DateTime, model.Adn_AddTime); db.AddInParameter(dbCommand, "Adn_Flag", DbType.Int32, model.Adn_Flag); db.AddInParameter(dbCommand, "Adn_RealName", DbType.String, model.Adn_RealName); db.AddInParameter(dbCommand, "Adn_SecurityID", DbType.AnsiString, model.Adn_SecurityID); db.AddInParameter(dbCommand, "Adn_IsWorker", DbType.Byte, model.Adn_IsWorker); db.AddInParameter(dbCommand, "Adn_SelfCard", DbType.AnsiString, model.Adn_SelfCard); db.AddInParameter(dbCommand, "OpenId", DbType.AnsiString, model.OpenId); db.AddInParameter(dbCommand, "Adn_IsConsultant", DbType.Int32, model.Adn_IsConsultant); db.AddInParameter(dbCommand, "Wx_FakeId", DbType.String, model.Wx_FakeId); db.AddInParameter(dbCommand, "Wx_NickName", DbType.String, model.Wx_NickName); db.AddInParameter(dbCommand, "Wx_ReMarkName", DbType.String, model.Wx_ReMarkName); db.AddInParameter(dbCommand, "Wx_Username", DbType.String, model.Wx_Username); db.AddInParameter(dbCommand, "Wx_Signature", DbType.String, model.Wx_Signature); db.AddInParameter(dbCommand, "Wx_Country", DbType.String, model.Wx_Country); db.AddInParameter(dbCommand, "Wx_Province", DbType.String, model.Wx_Province); db.AddInParameter(dbCommand, "Wx_City", DbType.String, model.Wx_City); db.AddInParameter(dbCommand, "Wx_Sex", DbType.Byte, model.Wx_Sex); db.AddInParameter(dbCommand, "Wx_GroupID", DbType.Int32, model.Wx_GroupID); db.AddInParameter(dbCommand, "Wx_GroupName", DbType.String, model.Wx_GroupName); db.AddInParameter(dbCommand, "Wx_UserImage", DbType.String, model.Wx_UserImage); db.AddInParameter(dbCommand, "Wx_Status", DbType.Byte, model.Wx_Status); db.AddInParameter(dbCommand, "Wx_MsgId", DbType.Int64, model.Wx_MsgId); db.AddInParameter(dbCommand, "Wx_MsgCreateDateTime", DbType.DateTime, model.Wx_MsgCreateDateTime); db.AddInParameter(dbCommand, "Wx_MsgContent", DbType.String, model.Wx_MsgContent); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }