/// <summary> /// 增加一条数据 /// </summary> public override void Add(dynamic obj, SqlTransaction tran = null) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_bm("); strSql.Append("cdefine4,cdefine5,cdefine6,ddefine7,ddefine8,ddefine9,ddefine10,code,name,fzr,sjbm,bz,cdefine1,cdefine2,cdefine3"); strSql.Append(") values ("); strSql.Append("@cdefine4,@cdefine5,@cdefine6,@ddefine7,@ddefine8,@ddefine9,@ddefine10,@code,@name,@fzr,@sjbm,@bz,@cdefine1,@cdefine2,@cdefine3"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@cdefine4", SqlDbType.VarChar, 100), new SqlParameter("@cdefine5", SqlDbType.VarChar, 100), new SqlParameter("@cdefine6", SqlDbType.VarChar, 300), new SqlParameter("@ddefine7", SqlDbType.Decimal, 9), new SqlParameter("@ddefine8", SqlDbType.Decimal, 9), new SqlParameter("@ddefine9", SqlDbType.DateTime), new SqlParameter("@ddefine10", SqlDbType.DateTime), new SqlParameter("@code", SqlDbType.VarChar, 30), new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@fzr", SqlDbType.VarChar, 50), new SqlParameter("@sjbm", SqlDbType.VarChar, 30), new SqlParameter("@bz", SqlDbType.VarChar, 200), new SqlParameter("@cdefine1", SqlDbType.VarChar, 10), new SqlParameter("@cdefine2", SqlDbType.VarChar, 30), new SqlParameter("@cdefine3", SqlDbType.VarChar, 30) }; t_bm model = (t_bm)obj; parameters[0].Value = SqlNull(model.cdefine4); parameters[1].Value = SqlNull(model.cdefine5); parameters[2].Value = SqlNull(model.cdefine6); parameters[3].Value = SqlNull(model.ddefine7); parameters[4].Value = SqlNull(model.ddefine8); parameters[5].Value = SqlNull(model.ddefine9); parameters[6].Value = SqlNull(model.ddefine10); parameters[7].Value = SqlNull(model.code); parameters[8].Value = SqlNull(model.name); parameters[9].Value = SqlNull(model.fzr); parameters[10].Value = SqlNull(model.sjbm); parameters[11].Value = SqlNull(model.bz); parameters[12].Value = SqlNull(model.cdefine1); parameters[13].Value = SqlNull(model.cdefine2); parameters[14].Value = SqlNull(model.cdefine3); if (tran == null) { DataHelper.ExcuteNonQuery(strSql.ToString(), parameters, false); } else { DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false); } }
/// <summary> ///Save,保存方法,先删除,再增加 /// </summary> public void Save(t_bm model, SqlTransaction tran = null) { SqlConnection conn = new SqlConnection(Dal.DataHelper.constr); conn.Open(); if (tran == null) { tran = conn.BeginTransaction(); } try { Delete(model, tran); Add(model, tran); tran.Commit(); conn.Close(); } catch (Exception e) { tran.Rollback(); conn.Close(); throw e; } }
//保存 public JsonResult Save(t_bm obj) { if (obj.list_id == -1) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("code", obj.code); var list = new Dal.Basedata.t_bmDal(dic, "code").ToList(); if (list.Count > 0) { return(Json(new { success = "error", message = ",该编号已经存在" })); } } try { new Dal.Basedata.t_bmDal().Save(obj); return(Json(new { success = "ok" })); } catch (Exception e) { return(Json(new { success = "error", message = e.Message })); } }