public CardManage.Model.CommLog GetModel(int ID) { CardManage.Model.CommLog model = null; MySqlParameter[] parameters = { new MySqlParameter("@SelNum", MySqlDbType.Int32), new MySqlParameter("@Where_String", MySqlDbType.VarChar) }; parameters[0].Value = 1; parameters[1].Value = string.Format("ID={0}", ID); DataSet ds = DbHelperSQL.RunProcedure(string.Format("{0}_GetBywhere_Num", this._TableName), parameters, "ds"); model.ID = ID; if (ds.Tables[0].Rows.Count > 0) { model = new CardManage.Model.CommLog(); DataRow dRow = ds.Tables[0].Rows[0]; model.Flag = Functions.FormatInt(dRow["Flag"]); model.FlagDesc = Functions.FormatString(dRow["FlagDesc"]); model.Content = Functions.FormatString(dRow["Content"]); model.CreateDate = Functions.FormatInt(dRow["CreateDate"]); return(model); } else { return(null); } }
public int Add(CardManage.Model.CommLog model, out string strErrorInfo) { strErrorInfo = ""; MySqlParameter[] parameters = { new MySqlParameter("@RtnInfo", MySqlDbType.VarChar, 500), new MySqlParameter("@NewID", MySqlDbType.Int32), new MySqlParameter("@Tag", MySqlDbType.Int32), //类型 new MySqlParameter("@ID", MySqlDbType.Int32), new MySqlParameter("@Flag", MySqlDbType.Int32), new MySqlParameter("@Content", SqlDbType.NText), new MySqlParameter("@CreateDate", MySqlDbType.Int32) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Direction = ParameterDirection.Output; parameters[2].Value = 0;//新增 parameters[3].Value = 0; parameters[4].Value = model.Flag; parameters[5].Value = model.Content; parameters[6].Value = model.CreateDate; try { DbHelperSQL.RunProcedure(string.Format("{0}_ADD_UPDATE", this._TableName), parameters, out int rowsAffected); strErrorInfo = Functions.FormatString(parameters[0].Value); int iNewID = Functions.FormatInt(parameters[1].Value); return(iNewID); } catch (MySqlException ex) { strErrorInfo = ex.Message; return(0); } }