/// <summary> /// 得到一个对象实体 /// </summary> static SMS.Model.ChargeRecord DataRowToModel(DataRow row) { SMS.Model.ChargeRecord model = new SMS.Model.ChargeRecord(); if (row != null) { if (row["OperatorAccount"] != null) { model.OperatorAccount = row["OperatorAccount"].ToString(); } if (row["PrepaidAccount"] != null) { model.PrepaidAccount = row["PrepaidAccount"].ToString(); } if (row["ThenRate"] != null && row["ThenRate"].ToString() != "") { model.ThenRate = decimal.Parse(row["ThenRate"].ToString()); } if (row["PrepaidType"] != null && row["PrepaidType"].ToString() != "") { model.PrepaidType = (ushort)row["PrepaidType"]; } if (row["Money"] != null && row["Money"].ToString() != "") { model.Money = decimal.Parse(row["Money"].ToString()); } if (row["SMSCount"] != null && row["SMSCount"].ToString() != "") { model.SMSCount = int.Parse(row["SMSCount"].ToString()); } if (row["RemainSMSCount"] != null && row["RemainSMSCount"].ToString() != "") { model.RemainSMSCount = int.Parse(row["RemainSMSCount"].ToString()); } if (row["PrepaidTime"] != null && row["PrepaidTime"].ToString() != "") { model.PrepaidTime = DateTime.Parse(row["PrepaidTime"].ToString()); } if (row["ChargeFlag"] != null && row["ChargeFlag"].ToString() != "") { model.ChargeFlag = (ushort)row["ChargeFlag"]; } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(SMS.Model.ChargeRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into plat_ChargeRecord("); strSql.Append("OperatorAccount,PrepaidAccount,ThenRate,PrepaidType,Money,SMSCount,RemainSMSCount,PrepaidTime,ChargeFlag,Remark)"); strSql.Append(" values ("); strSql.Append("@OperatorAccount,@PrepaidAccount,@ThenRate,@PrepaidType,@Money,@SMSCount,@RemainSMSCount,@PrepaidTime,@ChargeFlag,@Remark)"); MySqlParameter[] parameters = { new MySqlParameter("@OperatorAccount", MySqlDbType.VarChar, 32), new MySqlParameter("@PrepaidAccount", MySqlDbType.VarChar, 64), new MySqlParameter("@ThenRate", MySqlDbType.Decimal, 5), new MySqlParameter("@PrepaidType", MySqlDbType.Int32, 5), new MySqlParameter("@Money", MySqlDbType.Decimal, 10), new MySqlParameter("@SMSCount", MySqlDbType.Int32, 10), new MySqlParameter("@RemainSMSCount", MySqlDbType.Int32, 10), new MySqlParameter("@PrepaidTime", MySqlDbType.DateTime), new MySqlParameter("@ChargeFlag", MySqlDbType.Int32, 5), new MySqlParameter("@Remark", MySqlDbType.VarChar, 1024) }; parameters[0].Value = model.OperatorAccount; parameters[1].Value = model.PrepaidAccount; parameters[2].Value = model.ThenRate; parameters[3].Value = model.PrepaidType; parameters[4].Value = model.Money; parameters[5].Value = model.SMSCount; parameters[6].Value = model.RemainSMSCount; parameters[7].Value = model.PrepaidTime; parameters[8].Value = model.ChargeFlag; parameters[9].Value = model.Remark; int rows = DBUtility.MySqlHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }