/// <summary> /// 增加一条数据 /// </summary> public int Add(SOSOshop.Model.Qualifications model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Qualifications("); strSql.Append("DrugsBase_Enterprise_ID,Name,Attachment,Classify,ExpiryDate,AlertDate,IsTransition,IsYearCheck,Remark,Ceated)"); strSql.Append(" values ("); strSql.Append("@DrugsBase_Enterprise_ID,@Name,@Attachment,@Classify,@ExpiryDate,@AlertDate,@IsTransition,@IsYearCheck,@Remark,@Ceated)"); strSql.Append(";select @@IDENTITY"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "DrugsBase_Enterprise_ID", DbType.Int32, model.DrugsBase_Enterprise_ID); db.AddInParameter(dbCommand, "Name", DbType.Int32, model.Name); db.AddInParameter(dbCommand, "Attachment", DbType.String, model.Attachment); db.AddInParameter(dbCommand, "Classify", DbType.String, model.Classify); db.AddInParameter(dbCommand, "ExpiryDate", DbType.Int32, model.ExpiryDate); db.AddInParameter(dbCommand, "AlertDate", DbType.String, model.AlertDate); db.AddInParameter(dbCommand, "IsTransition", DbType.Boolean, model.IsTransition); db.AddInParameter(dbCommand, "IsYearCheck", DbType.Boolean, model.IsYearCheck); db.AddInParameter(dbCommand, "Remark", DbType.String, model.Remark); db.AddInParameter(dbCommand, "Ceated", DbType.DateTime, model.Ceated); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 对象实体绑定数据 /// </summary> public SOSOshop.Model.Qualifications ReaderBind(IDataReader dataReader) { SOSOshop.Model.Qualifications model = new SOSOshop.Model.Qualifications(); object ojb; ojb = dataReader["ID"]; if (ojb != null && ojb != DBNull.Value) { model.ID = (int)ojb; } ojb = dataReader["DrugsBase_Enterprise_ID"]; if (ojb != null && ojb != DBNull.Value) { model.DrugsBase_Enterprise_ID = (int)ojb; } ojb = dataReader["Name"]; if (ojb != null && ojb != DBNull.Value) { model.Name = (int)ojb; } model.Attachment = dataReader["Attachment"].ToString(); model.Classify = dataReader["Classify"].ToString(); ojb = dataReader["ExpiryDate"]; if (ojb != null && ojb != DBNull.Value) { model.ExpiryDate = (int)ojb; } ojb = dataReader["AlertDate"]; if (ojb != null && ojb != DBNull.Value) { model.AlertDate = (DateTime)ojb; } ojb = dataReader["IsTransition"]; if (ojb != null && ojb != DBNull.Value) { model.IsTransition = (bool)ojb; } ojb = dataReader["IsYearCheck"]; if (ojb != null && ojb != DBNull.Value) { model.IsYearCheck = (bool)ojb; } model.Remark = dataReader["Remark"].ToString(); ojb = dataReader["Ceated"]; if (ojb != null && ojb != DBNull.Value) { model.Ceated = (DateTime)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public SOSOshop.Model.Qualifications GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,DrugsBase_Enterprise_ID,Name,Attachment,Classify,ExpiryDate,AlertDate,IsTransition,IsYearCheck,Remark,Ceated from Qualifications "); strSql.Append(" where ID=@ID "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.Int32, ID); SOSOshop.Model.Qualifications model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SOSOshop.Model.Qualifications model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Qualifications set "); strSql.Append("DrugsBase_Enterprise_ID=@DrugsBase_Enterprise_ID,"); strSql.Append("Name=@Name,"); strSql.Append("Attachment=@Attachment,"); strSql.Append("Classify=@Classify,"); strSql.Append("ExpiryDate=@ExpiryDate,"); strSql.Append("AlertDate=@AlertDate,"); strSql.Append("IsTransition=@IsTransition,"); strSql.Append("IsYearCheck=@IsYearCheck,"); strSql.Append("Remark=@Remark,"); strSql.Append("Ceated=@Ceated"); strSql.Append(" where ID=@ID "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ID", DbType.Int32, model.ID); db.AddInParameter(dbCommand, "DrugsBase_Enterprise_ID", DbType.Int32, model.DrugsBase_Enterprise_ID); db.AddInParameter(dbCommand, "Name", DbType.Int32, model.Name); db.AddInParameter(dbCommand, "Attachment", DbType.String, model.Attachment); db.AddInParameter(dbCommand, "Classify", DbType.String, model.Classify); db.AddInParameter(dbCommand, "ExpiryDate", DbType.Int32, model.ExpiryDate); db.AddInParameter(dbCommand, "AlertDate", DbType.String, model.AlertDate); db.AddInParameter(dbCommand, "IsTransition", DbType.Boolean, model.IsTransition); db.AddInParameter(dbCommand, "IsYearCheck", DbType.Boolean, model.IsYearCheck); db.AddInParameter(dbCommand, "Remark", DbType.String, model.Remark); db.AddInParameter(dbCommand, "Ceated", DbType.DateTime, model.Ceated); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }