/// <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 }));
}
}
