public string CopyAndSaveData(string content, string userid)
{
var tran = Utility.Database.BeginDbTransaction();
try
{
B_OA_AddressBook baseInfo = new B_OA_AddressBook();
baseInfo.Condition.Add("id=" + content);
baseInfo = Utility.Database.QueryObject<B_OA_AddressBook>(baseInfo);// 获取客户端数据
var deptUserInfo = ComClass.GetDeptAndUserByUserId(userid);
B_OA_AddressBook copyEnt = new B_OA_AddressBook();// 实例化一个对象并给它赋值
copyEnt.name = baseInfo.name;
copyEnt.phone = baseInfo.phone;
copyEnt.unitphone = baseInfo.unitphone;
copyEnt.mobilephone = baseInfo.mobilephone;
copyEnt.fax = baseInfo.fax;
copyEnt.email = baseInfo.email;
copyEnt.dpid = deptUserInfo.deptinfo.DPID;
copyEnt.dpname = deptUserInfo.deptinfo.DPName;
copyEnt.userId = userid;
copyEnt.personal = 1;
copyEnt.createtime = DateTime.Now;// 创建时间
copyEnt.ownnerUserId = userid;
Utility.Database.Insert<B_OA_AddressBook>(copyEnt, tran);
var returnData = new B_OA_AddressBook();// 返回值
DataTable dt = Utility.Database.ExcuteDataSet("select @@identity;", tran).Tables[0];
returnData.Condition.Add("id=" + Convert.ToInt32(dt.Rows[0][0]));
returnData = Utility.Database.QueryObject<B_OA_AddressBook>(returnData, tran);
Utility.Database.Commit(tran);
tran.Dispose();
return Utility.JsonResult(true, "复制成功！", returnData);
}
catch (Exception ex)
{
ComBase.Logger(ex.Message);
Utility.Database.Rollback(tran);
return Utility.JsonResult(false, "复制失败！", ex.Message);
}
}
public string DeleteData(string content)
{
var tran = Utility.Database.BeginDbTransaction();
try
{
var delEnt = new B_OA_AddressBook();
delEnt.Condition.Add("id=" + content);
Utility.Database.Delete(delEnt, tran);
Utility.Database.Commit(tran);
tran.Dispose();
return Utility.JsonResult(true, "删除成功！");
}
catch (Exception ex)
{
ComBase.Logger(ex);
Utility.Database.Rollback(tran);
return Utility.JsonResult(false, ex.Message, null);
}
}
public object GetDatas(string content, string userid)
{
IDbTransaction tran = Utility.Database.BeginDbTransaction();
try
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("select id,name, phone, unitphone, mobilephone, fax, email, dpid, dpname, userId, personal, createtime, ownnerUserId from B_OA_AddressBook where ownnerUserId='{0}' order by createtime desc", userid);
DataSet ds = Utility.Database.ExcuteDataSet(strSql.ToString(), tran);
var data = new GetDataModel();// 获取数据
DataTable dataTable = ds.Tables[0];
B_OA_AddressBook sourceListEdit = new B_OA_AddressBook();
Utility.Database.Commit(tran);
return new
{
dataTable = dataTable,
sourceListEdit = sourceListEdit
};
}
catch (Exception ex)
{
ComBase.Logger(ex);
return Utility.JsonResult(false, ex.Message);
}
}
