public static void Updata(PettyCashmodel model, Guid GUID) { string queryString = $@" UPDATE 零用金 SET CaseID = @CaseID, date = @date, class = @cla , pay = @pay, Event = @Evn, invoiceCode = @invo , Updatetime = @Updatetime WHERE GUID = @GUID"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@GUID", GUID), new SqlParameter("@CaseID", model.CaseID), new SqlParameter("@date", model.Date), new SqlParameter("@cla", model.Class), new SqlParameter("@pay", model.pay), new SqlParameter("@Evn", model.Event), new SqlParameter("@invo", model.invoiceCode), new SqlParameter("@Updatetime", DateTime.Now) }; PettyCashmanager.ExecuteNonQuery(queryString, parameters); }
public static void insert(PettyCashmodel model) { string queryString = $@" INSERT INTO 零用金 (GUID,CaseID,Date,class,pay,Event,invoiceCode,Createtime,Isdelete) VALUES (@GUID,@CaseID,@date,@cla,@pay,@Evn,@invo,@Createtime,@Isdelete)"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@GUID", Guid.NewGuid()), new SqlParameter("@CaseID", model.CaseID), new SqlParameter("@date", model.Date), new SqlParameter("@cla", model.Class), new SqlParameter("@pay", model.pay), new SqlParameter("@Evn", model.Event), new SqlParameter("@invo", model.invoiceCode), new SqlParameter("@Createtime", DateTime.Now), new SqlParameter("@Isdelete", false) }; PettyCashmanager.ExecuteNonQuery(queryString, parameters); }