/// <summary> /// 增加一条数据 /// </summary> public int Add(JumbotOA.Entity.CallinfoEntity model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); strSql1.Append("Uid,"); strSql2.Append("" + model.Uid + ","); if (model.Userinfo != null) { strSql1.Append("Userinfo,"); strSql2.Append("'" + model.Userinfo + "',"); } if (model.Title != null) { strSql1.Append("Title,"); strSql2.Append("'" + model.Title + "',"); } if (model.Unit != null) { strSql1.Append("Unit,"); strSql2.Append("'" + model.Unit + "',"); } if (model.Addtime != null) { strSql1.Append("Addtime,"); strSql2.Append("'" + model.Addtime + "',"); } if (model.Reply != null) { strSql1.Append("Reply,"); strSql2.Append("'" + model.Reply + "',"); } if (model.Remark != null) { strSql1.Append("Remark,"); strSql2.Append("'" + model.Remark + "',"); } strSql.Append("insert into [OA_Callinfo]("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(JumbotOA.Entity.CallinfoEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [OA_Callinfo] set "); strSql.Append("Uid=" + model.Uid + ","); strSql.Append("Userinfo='" + model.Userinfo + "',"); strSql.Append("Title='" + model.Title + "',"); strSql.Append("Unit='" + model.Unit + "',"); strSql.Append("Addtime='" + model.Addtime + "',"); strSql.Append("Reply='" + model.Reply + "',"); strSql.Append("Remark='" + model.Remark + "'"); strSql.Append(" where Id=" + model.Id + " "); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public JumbotOA.Entity.CallinfoEntity GetEntity(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" * "); strSql.Append(" from [OA_Callinfo] "); strSql.Append(" where Id=" + Id + " "); JumbotOA.Entity.CallinfoEntity model = new JumbotOA.Entity.CallinfoEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if (ds.Tables[0].Rows[0]["Userinfo"].ToString() != "") { model.Userinfo = ds.Tables[0].Rows[0]["Userinfo"].ToString(); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString(); if (ds.Tables[0].Rows[0]["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(ds.Tables[0].Rows[0]["Addtime"].ToString()); } model.Reply = ds.Tables[0].Rows[0]["Reply"].ToString(); model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JumbotOA.Entity.CallinfoEntity GetEntity(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" * "); strSql.Append(" from [OA_Callinfo] "); strSql.Append(" where Id=" + Id + " "); JumbotOA.Entity.CallinfoEntity model = new JumbotOA.Entity.CallinfoEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["Uid"].ToString() != "") { model.Uid = int.Parse(ds.Tables[0].Rows[0]["Uid"].ToString()); } if (ds.Tables[0].Rows[0]["Userinfo"].ToString() != "") { model.Userinfo = ds.Tables[0].Rows[0]["Userinfo"].ToString(); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString(); if (ds.Tables[0].Rows[0]["Addtime"].ToString() != "") { model.Addtime = DateTime.Parse(ds.Tables[0].Rows[0]["Addtime"].ToString()); } model.Reply = ds.Tables[0].Rows[0]["Reply"].ToString(); model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); return model; } else { return null; } }