internal int EditB2bCrmLevel(B2bcrmlevels m) { if (m.id == 0) { string sql = @"INSERT INTO [EtownDB].[dbo].[B2bcrmlevels] ([crmlevel] ,[levelname] ,[dengjifen_begin] ,[dengjifen_end] ,[tequan] ,[com_id] ,[isavailable]) VALUES (@crmlevel ,@levelname ,@dengjifen_begin ,@dengjifen_end ,@tequan ,@com_id ,@isavailable);select @@identity;"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@crmlevel", m.crmlevel); cmd.AddParam("@levelname", m.levelname); cmd.AddParam("@dengjifen_begin", m.dengjifen_begin); cmd.AddParam("@dengjifen_end", m.dengjifen_end); cmd.AddParam("@tequan", m.tequan); cmd.AddParam("@com_id", m.com_id); cmd.AddParam("@isavailable", m.isavailable); object o = cmd.ExecuteScalar(); return(o == null ? 0 : int.Parse(o.ToString())); } else { string sql = @"UPDATE [EtownDB].[dbo].[B2bcrmlevels] SET [crmlevel] = @crmlevel ,[levelname] = @levelname ,[dengjifen_begin] = @dengjifen_begin ,[dengjifen_end] = @dengjifen_end ,[tequan] = @tequan ,[com_id] = @com_id ,[isavailable] = @isavailable WHERE id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", m.id); cmd.AddParam("@crmlevel", m.crmlevel); cmd.AddParam("@levelname", m.levelname); cmd.AddParam("@dengjifen_begin", m.dengjifen_begin); cmd.AddParam("@dengjifen_end", m.dengjifen_end); cmd.AddParam("@tequan", m.tequan); cmd.AddParam("@com_id", m.com_id); cmd.AddParam("@isavailable", m.isavailable); cmd.ExecuteNonQuery(); return(m.id); } }
public int EditB2bCrmLevel(B2bcrmlevels m) { using (var helper = new SqlHelper()) { int d = new InternalB2bcrmlevels(helper).EditB2bCrmLevel(m); return(d); } }
internal B2bcrmlevels Getb2bcrmlevelbyweixin(int comid, decimal djf_begin) { string sql = @"SELECT [id] ,[crmlevel] ,[levelname] ,[dengjifen_begin] ,[dengjifen_end] ,[tequan] ,[com_id] ,[isavailable] FROM [EtownDB].[dbo].[B2bcrmlevels] where com_id=@comid and dengjifen_begin=@djf_begin"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@comid", comid); cmd.AddParam("@djf_begin", djf_begin); using (var reader = cmd.ExecuteReader()) { B2bcrmlevels m = null; if (reader.Read()) { m = new B2bcrmlevels() { id = reader.GetValue <int>("id"), crmlevel = reader.GetValue <string>("crmlevel"), levelname = reader.GetValue <string>("levelname"), dengjifen_begin = reader.GetValue <decimal>("dengjifen_begin"), dengjifen_end = reader.GetValue <decimal>("dengjifen_end"), tequan = reader.GetValue <string>("tequan"), com_id = reader.GetValue <int>("com_id"), isavailable = reader.GetValue <int>("isavailable") }; } return(m); } }
/// <summary> /// 公司不含有会员级别设置,则录入默认级别 /// </summary> /// <param name="comid"></param> private void InsDefaultLevel(int comid) { for (int i = 1; i <= 4; i++) { if (i == 1) { B2bcrmlevels m = new B2bcrmlevels { id = 0, crmlevel = "A", levelname = "普通会员", dengjifen_begin = 0, dengjifen_end = 499, tequan = "享受普通会员权利", com_id = comid, isavailable = 1 }; int n = new B2bcrmlevelsData().EditB2bCrmLevel(m); } if (i == 2) { B2bcrmlevels m = new B2bcrmlevels { id = 0, crmlevel = "B", levelname = "铜牌会员", dengjifen_begin = 500, dengjifen_end = 1999, tequan = "享受铜牌会员权利", com_id = comid, isavailable = 1 }; int n = new B2bcrmlevelsData().EditB2bCrmLevel(m); } if (i == 3) { B2bcrmlevels m = new B2bcrmlevels { id = 0, crmlevel = "C", levelname = "银牌会员", dengjifen_begin = 2000, dengjifen_end = 4999, tequan = "享受银牌会员权利", com_id = comid, isavailable = 1 }; int n = new B2bcrmlevelsData().EditB2bCrmLevel(m); } if (i == 4) { B2bcrmlevels m = new B2bcrmlevels { id = 0, crmlevel = "D", levelname = "金牌会员", dengjifen_begin = 5000, dengjifen_end = 1000000000, tequan = "享受金牌会员权利", com_id = comid, isavailable = 1 }; int n = new B2bcrmlevelsData().EditB2bCrmLevel(m); } } }