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