/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.MsgData DataRowToModel(DataRow row) { Maticsoft.Model.MsgData model=new Maticsoft.Model.MsgData(); if (row != null) { if(row["MsgID"]!=null && row["MsgID"].ToString()!="") { model.MsgID=int.Parse(row["MsgID"].ToString()); } if(row["PhoneNumber"]!=null) { model.PhoneNumber=row["PhoneNumber"].ToString(); } if(row["Msg"]!=null) { model.Msg=row["Msg"].ToString(); } if(row["MsgTime"]!=null && row["MsgTime"].ToString()!="") { model.MsgTime=DateTime.Parse(row["MsgTime"].ToString()); } if(row["IsRecivedMsg"]!=null && row["IsRecivedMsg"].ToString()!="") { if((row["IsRecivedMsg"].ToString()=="1")||(row["IsRecivedMsg"].ToString().ToLower()=="true")) { model.IsRecivedMsg=true; } else { model.IsRecivedMsg=false; } } if(row["ReciveMsgStatus"]!=null) { model.ReciveMsgStatus=row["ReciveMsgStatus"].ToString(); } if(row["ReturnedID"]!=null) { model.ReturnedID=row["ReturnedID"].ToString(); } } return model; }
public int SaveMsgData(string phonenumber, string codes, bool RecivedMsg) { int i = 0; try { Maticsoft.Model.MsgData MsgDataModel = new Maticsoft.Model.MsgData(); MsgDataModel.IsRecivedMsg = RecivedMsg; MsgDataModel.Msg = codes; MsgDataModel.MsgTime = DateTime.Now; MsgDataModel.PhoneNumber = phonenumber; MsgDataModel.ReciveMsgStatus = ""; MsgDataModel.ReturnedID = ""; Maticsoft.DAL.MsgData dal = new Maticsoft.DAL.MsgData(); i = dal.Add(MsgDataModel); } catch (Exception) { i = -1; throw; } return i; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.MsgData GetModel(int MsgID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 MsgID,PhoneNumber,Msg,MsgTime,IsRecivedMsg,ReciveMsgStatus,ReturnedID from MsgData "); strSql.Append(" where MsgID=@MsgID"); SqlParameter[] parameters = { new SqlParameter("@MsgID", SqlDbType.Int,4) }; parameters[0].Value = MsgID; Maticsoft.Model.MsgData model=new Maticsoft.Model.MsgData(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }