private bool CheckRepeat(ProcessorsModel d)
{
object oTemp;
string sql_Repeat = "select 1 from T_UserInfo_Processors where (Number='" + d.Number + "' OR Name='" + d.Name + "') AND DeleteMark IS NULL AND Guid <> '" + d.Guid + "'";
return(new Helper.SQLite.DBHelper().QuerySingleResult(sql_Repeat, out oTemp));
}
internal bool Update(ProcessorsModel d)
{
if (CheckRepeat(d))
{
return(false);
}
string sql_Insert = "Update T_UserInfo_Processors "
+ " SET "
+ " Number='" + d.Number
+ "',Name='" + d.Name
+ "',Address='" + d.Address
+ "',Area='" + d.Area
+ "',Phone='" + d.Phone
+ "',MobilePhone='" + d.MobilePhone
+ "',Fax='" + d.Fax
+ "',Business='" + d.Business
+ "',Clerk='" + d.Clerk
+ "',OpeningBank='" + d.OpeningBank
+ "',BankCardNo='" + d.BankCardNo
+ "',BankCardName='" + d.BankCardName
+ "',Remark='" + d.Remark
+ "' WHERE GUID='" + d.Guid + "'";
return(new Helper.SQLite.DBHelper().SingleExecution(sql_Insert));
}
internal bool MarkDelete(ProcessorsModel d)
{
bool flag = true;
string sql = "Update T_UserInfo_Processors Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where GUID='" + d.Guid + "'";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool Add(ProcessorsModel d)
{
if (CheckRepeat(d))
{
return(false);
}
bool flag = true;
string sql = "Insert Into T_UserInfo_Processors(GUID,Number,Name,Address,Area,Phone,MobilePhone,Fax,Business,Clerk,OpeningBank,BankCardNo,BankCardName,Remark,AddTime) "
+ " values('" + d.Guid + "','" + d.Number + "','" + d.Name + "','" + d.Address + "','" + d.Area + "','" + d.Phone + "','" + d.MobilePhone + "','" + d.Fax + "','" + d.Business + "','" + d.Clerk + "','" + d.OpeningBank + "','" + d.BankCardNo + "','" + d.BankCardName + "','" + d.Remark + "','" + d.AddTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
flag = new Helper.SQLite.DBHelper().SingleExecution(sql);
return(flag);
}
internal bool ReadList(out List <ProcessorsModel> data)
{
bool flag = true;
data = new List <ProcessorsModel>();
string sql = "select * from T_UserInfo_Processors Where DeleteMark is null order by AddTime";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProcessorsModel d = new ProcessorsModel();
d.Guid = (Guid)dr["GUID"];
d.Id = id++;
d.Number = dr["Number"].ToString();
d.Name = dr["Name"].ToString();
d.Address = dr["Address"].ToString();
d.Area = dr["Area"].ToString();
d.Phone = dr["Phone"].ToString();
d.MobilePhone = dr["MobilePhone"].ToString();
d.Fax = dr["Fax"].ToString();
d.Business = dr["Business"].ToString();
d.Clerk = dr["Clerk"].ToString();
d.OpeningBank = dr["OpeningBank"].ToString();
d.BankCardNo = dr["BankCardNo"].ToString();
d.BankCardName = dr["BankCardName"].ToString();
d.Remark = dr["Remark"].ToString();
d.AddTime = Convert.ToDateTime(dr["AddTime"]);
data.Add(d);
}
}
return(flag);
}