private void InsertBusinessGroupLineMapping(int bgid, string lineids) { foreach (string key in lineids.Split(',')) { int id = CommonFunction.ObjectToInteger(key, -1); if (id >= 0) { Entities.BusinessGroupLineMapping model = new Entities.BusinessGroupLineMapping(); model.BGID = bgid; model.LineID = id; model.Status = 0; model.CreateUserID = BLL.Util.GetLoginUserID(); model.CreateTime = DateTime.Now; BLL.BusinessGroupLineMapping.Instance.Insert(model); } } }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.BusinessGroupLineMapping model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@BGID", SqlDbType.Int, 4), new SqlParameter("@LineID", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@CreateUserID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.BGID; parameters[2].Value = model.LineID; parameters[3].Value = model.Status; parameters[4].Value = model.CreateUserID; parameters[5].Value = DateTime.Now; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_BUSINESSGROUPLINEMAPPING_INSERT, parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.BusinessGroupLineMapping model) { Dal.BusinessGroupLineMapping.Instance.Insert(model); }