AdvertManage.Model.AMS_SchoolModel DataRowToAms_SchoolModel(DataRow dr) { AdvertManage.Model.AMS_SchoolModel model = new AdvertManage.Model.AMS_SchoolModel(); if (dr["Id"] != null && dr["Id"].ToString() != "") { model.Id = int.Parse(dr["Id"].ToString()); } if (dr["Number"] != null && dr["Number"].ToString() != "") { model.Number = dr["Number"].ToString(); } if (dr["Name"] != null && dr["Name"].ToString() != "") { model.Name = dr["Name"].ToString(); } if (dr["DTUip"] != null && dr["DTUip"].ToString() != "") { model.DTUip = dr["DTUip"].ToString(); } if (dr["Describe"] != null && dr["Describe"].ToString() != "") { model.Describe = dr["Describe"].ToString(); } if (dr["ConnectionString"] != null && dr["ConnectionString"].ToString() != "") { model.ConnectionString = dr["ConnectionString"].ToString(); } if (dr["Flag"] != null && dr["Flag"].ToString() != "") { model.Flag = int.Parse(dr["Flag"].ToString()); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(AdvertManage.Model.AMS_SchoolModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AMS_School("); strSql.Append("Number,Name,DTUip,Describe,ConnectionString,Flag)"); strSql.Append(" values ("); strSql.Append("@Number,@Name,@DTUip,@Describe,@ConnectionString,@Flag)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Number", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 30), new SqlParameter("@DTUip", SqlDbType.NVarChar, 20), new SqlParameter("@Describe", SqlDbType.NVarChar, 200), new SqlParameter("@ConnectionString", SqlDbType.NVarChar, 200), new SqlParameter("@Flag", SqlDbType.Int) }; parameters[0].Value = model.Number; parameters[1].Value = model.Name; parameters[2].Value = model.DTUip; parameters[3].Value = model.Describe; parameters[4].Value = model.ConnectionString; parameters[5].Value = model.Flag; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void button8_Click(object sender, RoutedEventArgs e) { CommandTypeItem cmdType = comboBox_SelectType.SelectedItem as CommandTypeItem; CommandHandleResultItem result = comboBox3.SelectedItem as CommandHandleResultItem; AdvertManage.Model.AMS_SchoolModel school = cbxSchool.SelectedItem as AdvertManage.Model.AMS_SchoolModel; ViewModel.BindCommandModel(school.Id, cmdType.TypeItem, result.HandleResult); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AdvertManage.Model.AMS_SchoolModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AMS_School set "); strSql.Append("Number=@Number,"); strSql.Append("Name=@Name,"); strSql.Append("DTUip=@DTUip,"); strSql.Append("Describe=@Describe,"); strSql.Append("ConnectionString=@ConnectionString,"); strSql.Append("Flag=@Flag"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Number", SqlDbType.NVarChar, 50), new SqlParameter("@Name", SqlDbType.NVarChar, 30), new SqlParameter("@DTUip", SqlDbType.NVarChar, 20), new SqlParameter("@Describe", SqlDbType.NVarChar, 200), new SqlParameter("@ConnectionString", SqlDbType.NVarChar, 200), new SqlParameter("@Flag", SqlDbType.Int), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.Number; parameters[1].Value = model.Name; parameters[2].Value = model.DTUip; parameters[3].Value = model.Describe; parameters[4].Value = model.ConnectionString; parameters[5].Value = model.Flag; parameters[6].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }