public bool Add(int type, string title, string Number, string opentime, string NumberAll = "") { int num = LotterySum.SumNumber(Number); using (DbOperHandler dbOperHandler = new ComData().Doh()) { NumberAll = string.IsNullOrEmpty(NumberAll) ? Number : NumberAll; dbOperHandler.Reset(); dbOperHandler.AddFieldItem("Type", (object)type); dbOperHandler.AddFieldItem("Title", (object)title); dbOperHandler.AddFieldItem("Number", (object)Number); dbOperHandler.AddFieldItem("NumberAll", (object)NumberAll); dbOperHandler.AddFieldItem("Total", (object)num); dbOperHandler.AddFieldItem("Opentime", (object)opentime); dbOperHandler.AddFieldItem("IsFill", (object)"1"); if (dbOperHandler.Insert("Sys_LotteryData") > 0) { return(true); } } return(false); }
public void SaveUserRegLink(string UserId, decimal Point, string Url) { using (DbOperHandler dbOperHandler = new ComData().Doh()) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = string.Concat(new object[] { "UserId=", UserId, " and Point=", Point }); if (dbOperHandler.Exist("N_UserRegLink")) { dbOperHandler.Reset(); dbOperHandler.ConditionExpress = string.Concat(new object[] { "UserId=", UserId, " and Point=", Point }); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("Point", Point); dbOperHandler.AddFieldItem("Url", Url); dbOperHandler.Update("N_UserRegLink"); } else { dbOperHandler.Reset(); dbOperHandler.AddFieldItem("UserId", UserId); dbOperHandler.AddFieldItem("Point", Point); dbOperHandler.AddFieldItem("Url", Url); dbOperHandler.Insert("N_UserRegLink"); } } }