//保存 private void Btn_Save_Click(object sender, EventArgs e) { bool Flag = true; C_Alias AliasItem; DataGridViewRowCollection dgr = this.Gv_Alias.Rows; DataGridViewCellCollection Dgc; this.Gv_Alias.EndEdit(); for (int i = 0; i < dgr.Count; i++) { AliasItem = new C_Alias(); Dgc = this.Gv_Alias.Rows[i].Cells; AliasItem.Id = Convert.ToInt64(Dgc["Col_Id"].Value); AliasItem.Name =Dgc["Col_Name"].FormattedValue.ToString().Trim(); AliasItem.State=(bool)Dgc["Col_State"].Value; if (AliasItem.Name == "") { Function.MessageWarning("名称不允许为空!"); return; } if (!AliasBLL.Update(AliasItem)) { Flag = false; return; } } if (Flag) { Function.Message("修改成功!"); DataBind(); } }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(C_Alias Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new AliasDAL(); bool Flag = false, ReFlag = false; int N = 0; SqlParameter[] prams ={ db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@State", SqlDbType.Bit,0, Item.State), db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id) }; try { ReFlag = db.TransactSql(visitor, "Update", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }