public string SaveSuggest(string content, string name, string phone) { T_Suggestion t = new T_Suggestion() { Name = name, Phone = phone, Content = content, CreateDate = DateTime.Now, Processed = false }; int i = B_Common.AddSuggestion(t); return(i > 0 ? "" : "Error"); }
public static int AddSuggestion(T_Suggestion s) { object o = MySqlHelper.ExecuteScalar(Util.GetConnectString(HomeConnString), "insert into T_Suggestion(Id, Name, Phone, Content, CreateDate, Processed) values (null, @Name, @Phone, @Content, @CreateDate, @Processed); select last_insert_id();", "@Name".ToVarCharInPara(s.Name), "@Phone".ToVarCharInPara(s.Phone), "@Content".ToVarCharInPara(s.Content), "@CreateDate".ToDateTimeInPara(s.CreateDate), "@Processed".ToBitInPara(s.Processed) ); return(o == null ? 0 : int.Parse(o.ToString())); }