public static object Edit(int?id)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
TTelBook entity = null;
if (id != null)
{
entity = dbContext.TTelBook.FirstOrDefault(t => t.编码 == id);
}
entity = entity ?? new TTelBook
{
编码 = 0,
称 = "",
电话分类编码 = -1,
联系电话一 = "",
联系电话二 = "",
分机一 = "",
分机二 = "",
备注 = "",
顺序号 = 1,
是否有效 = true
};
return(entity);
}
}
public static bool Save(TTelBook entity)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
if (entity.编码 == 0) //添加
{
var list = from p in dbContext.TTelBook select p.编码;
long total = list.LongCount();
if (total == 0)
{
entity.编码 = 1;
entity.顺序号 = 1;
}
else
{
entity.编码 = dbContext.TTelBook.Max(t => t.编码) + 1;
entity.顺序号 = dbContext.TTelBook.Max(t => t.顺序号) + 1;
}
dbContext.TTelBook.InsertOnSubmit(entity);
dbContext.SubmitChanges();
return(true);
}
else //修改
{
var model = dbContext.TTelBook.FirstOrDefault(t => t.编码 == entity.编码);
model.编码 = entity.编码;
model.称 = entity.称;
model.电话分类编码 = entity.电话分类编码;
model.是否有效 = entity.是否有效;
model.分机一 = entity.分机一;
model.联系电话一 = entity.联系电话一;
model.联系电话二 = entity.联系电话二;
model.分机二 = entity.分机二;
model.备注 = entity.备注;
model.顺序号 = entity.顺序号;
dbContext.SubmitChanges();
return(true);
}
}
}
/// <summary>
/// 将DataSet中的数据导入数据库
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static bool InsertUnsale(DataTable dt)
{
using (MainDataContext dbContext = new MainDataContext(AppConfig.ConnectionStringDispatch))
{
int Num = dbContext.TTelBook.Max(t => t.编码);
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TTelBook book = new TTelBook();
book.编码 = Num + 1;
book.称 = Excel.FormatString(dt.Rows[i]["名称"].ToString());
book.联系电话一 = Excel.FormatString(dt.Rows[i]["联系电话一"].ToString());
book.分机一 = Excel.FormatString(dt.Rows[i]["分机一"].ToString());
book.联系电话二 = Excel.FormatString(dt.Rows[i]["联系电话二"].ToString());
book.分机二 = Excel.FormatString(dt.Rows[i]["分机二"].ToString());
book.备注 = Excel.FormatString(dt.Rows[i]["备注"].ToString());
book.顺序号 = int.Parse(Excel.FormatString(dt.Rows[i]["顺序号"].ToString()));
book.是否有效 = true;
string type = Excel.FormatString(dt.Rows[i]["电话分类"].ToString());
book.电话分类编码 = dbContext.TZTelType.FirstOrDefault(t => t.称 == type).编码;
dbContext.TTelBook.InsertOnSubmit(book);
Num++;
}
dbContext.SubmitChanges();
return(true);
}
catch (Exception e)
{
Log4Net.LogError("Anchor.FA.DAL.BasicInfo.TelBook/InsertUnsale()", e.Message);
return(false);
}
}
}
public bool Save(TTelBook entity)
{
return DAL.BasicInfo.TelBook.Save(entity);
}
