//修改记录函数
public bool Modify(Model.Contact model, out string msg)
{
if (!CheckModify(model, out msg))
{
return(false);
}
else
{
return(dal.Modify(model));
}
}
//添加记录函数
public bool Update(Model.Contact model, out string msg)
{
if (!CheckModel(model, out msg))
{
return(false);
}
else
{
return(dal.Update(model));
}
}
public bool CheckModel(Model.Contact model, out string msg)
{
bool check = true;
msg = "";
if (model.Name == "")
{
msg = "联系人姓名不能为空！";
check = false;
return(check);
}
if (!Utility.CheckMobilePhone(model.Phone)) // 需要添加引用和using 命名空间
{
msg = "手机号码不正确！";
check = false;
return(check);
}
if (!Utility.CheckEmail(model.Email))
{
msg = "Email 格式不正确!";
check = false;
return(check);
}
if (!Utility.CheckQQ(model.QQ))
{
msg = "QQ 号码不正确！";
check = false;
return(check);
}
if (!Utility.CheckPhone(model.OfficePhone))
{
msg = "办公电话不正确！";
check = false;
return(check);
}
if (!Utility.CheckPhone(model.HomePhone))
{
msg = "家庭电话不正确！";
check = false;
return(check);
}
return(check);
}
public bool CheckModify(Model.Contact model, out string msg)
{
bool check = true;
msg = "需要修改的记录不存在";
if (model.Table == "department")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_departments) || Utility.Check(model.Old_start_time) || Utility.Check(model.Departments) || Utility.Check(model.scrap_date) || Utility.Check(model.End_time) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.End_time))
{
msg = "时间格式不正确";
check = false;
return(check);
}
}
if (model.Table == "rent")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_tenant) || Utility.Check(model.Old_start_time) || Utility.Check(model.Tenant) || Utility.Check(model.scrap_date) || Utility.Check(model.End_time) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.End_time))
{
msg = "时间格式不正确";
check = false;
return(check);
}
}
if (model.Table == "repair")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_money) || Utility.Check(model.Old_start_time) || Utility.Check(model.Money) || Utility.Check(model.scrap_date) || Utility.Check(model.End_time) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason) || Utility.Check(model.Repair_reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.End_time))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Old_money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "scrap")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_name) || Utility.Check(model.Buy_price) || Utility.Check(model.Buy_date) || Utility.Check(model.Scrap_date) || Utility.Check(model.Name) || Utility.Check(model.Old_date) || Utility.Check(model.Old_start_time) || Utility.Check(model.Money) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Buy_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Buy_price))
{
msg = "金额格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Old_money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "acuumulated_depreciation")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_money) || Utility.Check(model.Old_date) || Utility.Check(model.Now) || Utility.Check(model.Date) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Old_money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Now))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "value_decrease")
{
if (Utility.Check(model.Id) || Utility.Check(model.Old_money) || Utility.Check(model.Old_date) || Utility.Check(model.Sum) || Utility.Check(model.Date) || Utility.Check(model.Recorder) || Utility.Check(model.Inspecter) || Utility.Check(model.Reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Old_money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Sum))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
return(check);
}
//判断信息是否符合规范
public bool CheckModel(Model.Contact model, out string msg)
{
bool check = true;
msg = "资产编号不存在";
if (model.Table == "summary")
{
msg = "资产编号已存在";
if (Utility.Check(model.Price) || Utility.Check(model.Name) || Utility.Check(model.Id))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Buy_time))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Discard_time))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Price))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "department")
{
if (Utility.Check(model.Id) || Utility.Check(model.Departments))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
}
if (model.Table == "repair")
{
if (Utility.Check(model.Money) || Utility.Check(model.Id) || Utility.Check(model.Repair_reason))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Money))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "accumulated_depreciation")
{
if (Utility.Check(model.Sum) || Utility.Check(model.Id))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Now))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "value_decrease")
{
if (Utility.Check(model.Buy_price) || Utility.Check(model.Id))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Sum))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "scrap")
{
if (Utility.Check(model.Name) || Utility.Check(model.Id) || Utility.Check(model.Buy_price))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Buy_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckTime(model.Scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
if (!Utility.CheckMoney(model.Buy_price))
{
msg = "金额格式不正确";
check = false;
return(check);
}
}
if (model.Table == "rent")
{
if (Utility.Check(model.Tenant) || Utility.Check(model.Id))
{
msg = "记录不能为空";
check = false;
return(check);
}
if (!Utility.CheckId(model.Id))
{
msg = "资产编号只能为数字";
check = false;
return(check);
}
if (!Utility.CheckTime(model.scrap_date))
{
msg = "时间格式不正确";
check = false;
return(check);
}
}
return(check);
}
//显示数据函数
public DataTable GetList(string strWhere, Model.Contact model)
{
return(dal.GetList(strWhere, model));
}
public void change_scrap_time(Model.Contact model)
{
SQLDAL.Change.change_scrap_time(model);
}
//修改summary表的剩余价值（当修改减值表或者累计折扣表）
public void change_remain_state_change(Model.Contact model)
{
SQLDAL.Change.change_remain_state_change(model);
}
//修改summary表的减值金额
public void change_dc_state(Model.Contact model)
{
SQLDAL.Change.change_dc_state(model);
}
//修改summary表的归属部门
public void change_dp(Model.Contact model)
{
SQLDAL.Change.change_dp(model);
}
