/// <summary> /// 获得数据列表 /// </summary> public List <lgk.Model.tb_TicketCity> DataTableToList(DataTable dt) { List <lgk.Model.tb_TicketCity> modelList = new List <lgk.Model.tb_TicketCity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { lgk.Model.tb_TicketCity model; for (int n = 0; n < rowsCount; n++) { model = new lgk.Model.tb_TicketCity(); if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["Name"] != null && dt.Rows[n]["Name"].ToString() != "") { model.Name = dt.Rows[n]["Name"].ToString(); } if (dt.Rows[n]["Code"] != null && dt.Rows[n]["Code"].ToString() != "") { model.Code = dt.Rows[n]["Code"].ToString(); } if (dt.Rows[n]["City"] != null && dt.Rows[n]["City"].ToString() != "") { model.City = dt.Rows[n]["City"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TicketCity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_TicketCity set "); strSql.Append("Name=@Name,"); strSql.Append("Code=@Code,"); strSql.Append("City=@City"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 100), new SqlParameter("@Code", SqlDbType.VarChar, 100), new SqlParameter("@City", SqlDbType.VarChar, 100), new SqlParameter("@ID", SqlDbType.Int) }; parameters[0].Value = model.Name; parameters[1].Value = model.Code; parameters[2].Value = model.City; parameters[3].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TicketCity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_TicketCity("); strSql.Append("Name,Code,City)"); strSql.Append(" values ("); strSql.Append("@Name,@Code,@City)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 100), new SqlParameter("@Code", SqlDbType.VarChar, 100), new SqlParameter("@City", SqlDbType.VarChar, 100) }; parameters[0].Value = model.Name; parameters[1].Value = model.Code; parameters[2].Value = model.City; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public lgk.Model.tb_TicketCity GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Name,Code,City from tb_TicketCity "); strSql.Append(" where " + where); lgk.Model.tb_TicketCity model = new lgk.Model.tb_TicketCity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), null); 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]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "") { model.Name = ds.Tables[0].Rows[0]["Name"].ToString(); } if (ds.Tables[0].Rows[0]["Code"] != null && ds.Tables[0].Rows[0]["Code"].ToString() != "") { model.Code = ds.Tables[0].Rows[0]["Code"].ToString(); } if (ds.Tables[0].Rows[0]["City"] != null && ds.Tables[0].Rows[0]["City"].ToString() != "") { model.City = ds.Tables[0].Rows[0]["City"].ToString(); } return(model); } else { return(null); } }
protected void LinkButton2_Click(object sender, EventArgs e) { if (textName.Value == "") { MessageBox.Show(this.Page, "机场名称不能为空"); return; } if (textCode.Value == "") { MessageBox.Show(this.Page, "三字代码不能为空"); return; } lgk.Model.tb_TicketCity model = new lgk.Model.tb_TicketCity(); model.Name = textName.Value; model.Code = textCode.Value; model.City = city.Value; lgk.Model.tb_TicketCity ischeck = cotybll.GetModel(" Name='" + textName.Value + "'"); if (ischeck == null) { cotybll.Add(model); } else { MessageBox.Show(this.Page, "该机场已存在"); } }
/// <summary> /// 将数据保存到数据库 /// </summary> /// <param name="dt_user"></param> protected void SaveToDataBase(System.Data.DataTable dt_user) { //创建事务s SqlTransaction trans_user = null; SqlConnection con = new SqlConnection(PubConstant.ConnectionString); con.Open(); //事务开始 trans_user = con.BeginTransaction(); try { for (int i = 0; i < dt_user.Rows.Count; i++) { string sql = ""; lgk.Model.tb_TicketCity city = cotybll.GetModel("Name='" + dt_user.Rows[i][0].ToString() + "'"); if (city == null) { sql = "insert into tb_TicketCity (Name,Code,City) values ('" + dt_user.Rows[i][0].ToString() + "','" + dt_user.Rows[i][1].ToString() + "','" + dt_user.Rows[i][2].ToString() + "')"; } else { sql = "update tb_TicketCity set Code='" + dt_user.Rows[i][1].ToString() + "' where Name='" + dt_user.Rows[i][0].ToString() + "'"; } object obj = DbHelperSQL.GetSingle(sql.ToString()); } trans_user.Commit(); //flagOk = true; MessageBox.Show(this.Page, "数据导入成功!"); } catch (Exception ex) { trans_user.Rollback(); MessageBox.Show(this.Page, "数据导入失败!" + ex.ToString().Substring(0, ex.ToString().IndexOf("。") + 1) + " <br />请检查文件内容后重新导入!"); } finally { con.Close(); trans_user = null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_TicketCity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(lgk.Model.tb_TicketCity model) { return(dal.Add(model)); }