public bool AdddateShopconfig(M_Shopconfig sinfo) { string sqlStr = "insert into ZL_Shopconfig(IsOpen,BankInfo,Anonymity,Pointcard,Dummymoney,Comment,goodpl,centerpl,badpl,Auditing,ScorePoint,ChangeOrder) values (@IsOpen,@BankInfo,@Anonymity,@Pointcard,@Dummymoney,@Comment,@goodpl,@centerpl,@badpl,@Auditing,@ScorePoint,@ChangeOrder)"; SqlParameter[] sp = sinfo.GetParameters(); return(SqlHelper.ExecuteSql(sqlStr, sp)); }
public bool UpdateShopconfig(M_Shopconfig sinfo) { string str = "Update " + strTableName + " Set IsOpen=@IsOpen,BankInfo=@BankInfo,Anonymity=@Anonymity,Pointcard=@Pointcard,Dummymoney=@Dummymoney,Comment=@Comment,goodpl=@goodpl, centerpl=@centerpl, badpl=@badpl,Auditing=@Auditing,ScorePoint=@ScorePoint,ChangeOrder=@ChangeOrder"; SqlParameter[] sp = sinfo.GetParameters(); return(SqlHelper.ExecuteSql(str, sp)); }