/// <summary> /// 增加一条数据 /// </summary> public bool Add(AMS.Model.View_SlipReleaseCampus model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into View_SlipReleaseCampus("); strSql.Append("id,SchoolNum,SchoolName,CampusId,CampusNum,CampusName,SlipCustomerId,SlipCustomerNum,SlipTemplate,IsPrint,SlipType,SlipEndDate,SlipEffectDate,CustomerImage,SlipImageUrl,SlipName,CouponsXml,SlipCustomerDescribe)"); strSql.Append(" values ("); strSql.Append("@id,@SchoolNum,@SchoolName,@CampusId,@CampusNum,@CampusName,@SlipCustomerId,@SlipCustomerNum,@SlipTemplate,@IsPrint,@SlipType,@SlipEndDate,@SlipEffectDate,@CustomerImage,@SlipImageUrl,@SlipName,@CouponsXml,@SlipCustomerDescribe)"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@SchoolNum", SqlDbType.NVarChar, 50), new SqlParameter("@SchoolName", SqlDbType.NVarChar, 30), new SqlParameter("@CampusId", SqlDbType.Int, 4), new SqlParameter("@CampusNum", SqlDbType.NVarChar, 50), new SqlParameter("@CampusName", SqlDbType.NVarChar, 50), new SqlParameter("@SlipCustomerId", SqlDbType.Int, 4), new SqlParameter("@SlipCustomerNum", SqlDbType.NVarChar, 50), new SqlParameter("@SlipTemplate", SqlDbType.Text), new SqlParameter("@IsPrint", SqlDbType.Bit, 1), new SqlParameter("@SlipType", SqlDbType.Int, 4), new SqlParameter("@SlipEndDate", SqlDbType.DateTime), new SqlParameter("@SlipEffectDate", SqlDbType.DateTime), new SqlParameter("@CustomerImage", SqlDbType.NVarChar, 200), new SqlParameter("@SlipImageUrl", SqlDbType.NVarChar, 200), new SqlParameter("@SlipName", SqlDbType.NVarChar, 50), new SqlParameter("@CouponsXml", SqlDbType.Text), new SqlParameter("@SlipCustomerDescribe", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.id; parameters[1].Value = model.SchoolNum; parameters[2].Value = model.SchoolName; parameters[3].Value = model.CampusId; parameters[4].Value = model.CampusNum; parameters[5].Value = model.CampusName; parameters[6].Value = model.SlipCustomerId; parameters[7].Value = model.SlipCustomerNum; parameters[8].Value = model.SlipTemplate; parameters[9].Value = model.IsPrint; parameters[10].Value = model.SlipType; parameters[11].Value = model.SlipEndDate; parameters[12].Value = model.SlipEffectDate; parameters[13].Value = model.CustomerImage; parameters[14].Value = model.SlipImageUrl; parameters[15].Value = model.SlipName; parameters[16].Value = model.CouponsXml; parameters[17].Value = model.SlipCustomerDescribe; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.View_SlipReleaseCampus GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,SchoolNum,SchoolName,CampusId,CampusNum,CampusName,SlipCustomerId,SlipCustomerNum,SlipTemplate,IsPrint,SlipType,SlipEndDate,SlipEffectDate,CustomerImage,SlipImageUrl,SlipName,CouponsXml,SlipCustomerDescribe from View_SlipReleaseCampus "); strSql.Append(" where "); SqlParameter[] parameters = { }; AMS.Model.View_SlipReleaseCampus model = new AMS.Model.View_SlipReleaseCampus(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["SchoolNum"] != null && ds.Tables[0].Rows[0]["SchoolNum"].ToString() != "") { model.SchoolNum = ds.Tables[0].Rows[0]["SchoolNum"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolName"] != null && ds.Tables[0].Rows[0]["SchoolName"].ToString() != "") { model.SchoolName = ds.Tables[0].Rows[0]["SchoolName"].ToString(); } if (ds.Tables[0].Rows[0]["CampusId"] != null && ds.Tables[0].Rows[0]["CampusId"].ToString() != "") { model.CampusId = int.Parse(ds.Tables[0].Rows[0]["CampusId"].ToString()); } if (ds.Tables[0].Rows[0]["CampusNum"] != null && ds.Tables[0].Rows[0]["CampusNum"].ToString() != "") { model.CampusNum = ds.Tables[0].Rows[0]["CampusNum"].ToString(); } if (ds.Tables[0].Rows[0]["CampusName"] != null && ds.Tables[0].Rows[0]["CampusName"].ToString() != "") { model.CampusName = ds.Tables[0].Rows[0]["CampusName"].ToString(); } if (ds.Tables[0].Rows[0]["SlipCustomerId"] != null && ds.Tables[0].Rows[0]["SlipCustomerId"].ToString() != "") { model.SlipCustomerId = int.Parse(ds.Tables[0].Rows[0]["SlipCustomerId"].ToString()); } if (ds.Tables[0].Rows[0]["SlipCustomerNum"] != null && ds.Tables[0].Rows[0]["SlipCustomerNum"].ToString() != "") { model.SlipCustomerNum = ds.Tables[0].Rows[0]["SlipCustomerNum"].ToString(); } if (ds.Tables[0].Rows[0]["SlipTemplate"] != null && ds.Tables[0].Rows[0]["SlipTemplate"].ToString() != "") { model.SlipTemplate = ds.Tables[0].Rows[0]["SlipTemplate"].ToString(); } if (ds.Tables[0].Rows[0]["IsPrint"] != null && ds.Tables[0].Rows[0]["IsPrint"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsPrint"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsPrint"].ToString().ToLower() == "true")) { model.IsPrint = true; } else { model.IsPrint = false; } } if (ds.Tables[0].Rows[0]["SlipType"] != null && ds.Tables[0].Rows[0]["SlipType"].ToString() != "") { model.SlipType = int.Parse(ds.Tables[0].Rows[0]["SlipType"].ToString()); } if (ds.Tables[0].Rows[0]["SlipEndDate"] != null && ds.Tables[0].Rows[0]["SlipEndDate"].ToString() != "") { model.SlipEndDate = DateTime.Parse(ds.Tables[0].Rows[0]["SlipEndDate"].ToString()); } if (ds.Tables[0].Rows[0]["SlipEffectDate"] != null && ds.Tables[0].Rows[0]["SlipEffectDate"].ToString() != "") { model.SlipEffectDate = DateTime.Parse(ds.Tables[0].Rows[0]["SlipEffectDate"].ToString()); } if (ds.Tables[0].Rows[0]["CustomerImage"] != null && ds.Tables[0].Rows[0]["CustomerImage"].ToString() != "") { model.CustomerImage = ds.Tables[0].Rows[0]["CustomerImage"].ToString(); } if (ds.Tables[0].Rows[0]["SlipImageUrl"] != null && ds.Tables[0].Rows[0]["SlipImageUrl"].ToString() != "") { model.SlipImageUrl = ds.Tables[0].Rows[0]["SlipImageUrl"].ToString(); } if (ds.Tables[0].Rows[0]["SlipName"] != null && ds.Tables[0].Rows[0]["SlipName"].ToString() != "") { model.SlipName = ds.Tables[0].Rows[0]["SlipName"].ToString(); } if (ds.Tables[0].Rows[0]["CouponsXml"] != null && ds.Tables[0].Rows[0]["CouponsXml"].ToString() != "") { model.CouponsXml = ds.Tables[0].Rows[0]["CouponsXml"].ToString(); } if (ds.Tables[0].Rows[0]["SlipCustomerDescribe"] != null && ds.Tables[0].Rows[0]["SlipCustomerDescribe"].ToString() != "") { model.SlipCustomerDescribe = ds.Tables[0].Rows[0]["SlipCustomerDescribe"].ToString(); } return(model); } else { return(null); } }