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));
}
