/// <summary> /// 增加一条数据 /// </summary> public int Add(Daiv_OA.Entity.MechanicalEntity model) { if (Exists(model.MechIMEI, model.Gid))//已经存在该设备 { throw new Exception("设备号已经存在!"); } StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); model.IsDeleted = 0; if (model.MechName != null) { strSql1.Append("MechName,"); strSql2.Append("'" + model.MechName + "',"); } if (model.MechIMEI != null) { strSql1.Append("MechIMEI,"); strSql2.Append("'" + model.MechIMEI + "',"); } if (model.MechPhone != null) { strSql1.Append("MechPhone,"); strSql2.Append("'" + model.MechPhone + "',"); } if (model.ClassName != null) { strSql1.Append("ClassName,"); strSql2.Append("'" + model.ClassName + "',"); } if (model.Gid > 0) { strSql1.Append("Gid,"); strSql2.Append("" + model.Gid + ","); } if (model.IsDeleted >= 0) { strSql1.Append("IsDeleted,"); strSql2.Append("0,"); } strSql.Append("insert into [OA_Mechanical]("); 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> /// <param name="dt"></param> /// <param name="rowindex"></param> /// <returns></returns> public Daiv_OA.Entity.MechanicalEntity ConvertModel(DataTable dt, int rowindex) { Daiv_OA.Entity.MechanicalEntity model = new Daiv_OA.Entity.MechanicalEntity(); try { if (dt.Rows[rowindex]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[rowindex]["ID"].ToString()); } model.MechName = dt.Rows[rowindex]["MechName"].ToString(); model.MechIMEI = dt.Rows[rowindex]["MechIMEI"].ToString(); model.MechPhone = dt.Rows[rowindex]["MechPhone"].ToString(); model.ClassName = dt.Rows[rowindex]["ClassName"].ToString(); if (dt.Rows[rowindex]["Gid"].ToString() != "") { model.Gid = int.Parse(dt.Rows[rowindex]["Gid"].ToString()); } if (dt.Rows[rowindex]["IsDeleted"].ToString() != "") { model.IsDeleted = int.Parse(dt.Rows[rowindex]["IsDeleted"].ToString()); } } catch (Exception ex) { log.Info("转换成用户对象失败!原因:" + ex.Message); return(new Entity.MechanicalEntity()); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Daiv_OA.Entity.MechanicalEntity GetEntityByImeiAndGid(string imei, int gid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" ID,MechName ,MechIMEI ,MechPhone,ClassName,Gid ,IsDeleted "); strSql.Append(" FROM [OA_Mechanical] "); strSql.Append(" where IsDeleted = 0 and MechIMEI=@imei and Gid=@gid "); Daiv_OA.Entity.MechanicalEntity model = new Daiv_OA.Entity.MechanicalEntity(); SqlParameter[] parameters = { new SqlParameter("@gid", SqlDbType.Int, 4), new SqlParameter("@imei", SqlDbType.NVarChar, 512) }; parameters[0].Value = gid; parameters[1].Value = imei; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(ConvertModel(ds.Tables[0], 0)); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Daiv_OA.Entity.MechanicalEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [OA_Mechanical] set "); strSql.Append("MechName='" + model.MechName + "',"); strSql.Append("MechIMEI='" + model.MechIMEI + "',"); strSql.Append("ClassName='" + model.ClassName + "',"); strSql.Append("Gid=" + model.Gid + ","); strSql.Append("MechPhone='" + model.MechPhone + "'");//注意: 最后不需要加逗号 strSql.Append(" where ID=" + model.ID + " "); DbHelperSQL.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public Daiv_OA.Entity.MechanicalEntity GetEntityByImei(string imei) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" ID,MechName ,MechIMEI ,MechPhone,ClassName,Gid ,IsDeleted "); strSql.Append(" FROM [OA_Mechanical] "); strSql.Append(" where IsDeleted = 0 and MechIMEI='" + imei + "' "); Daiv_OA.Entity.MechanicalEntity model = new Daiv_OA.Entity.MechanicalEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(ConvertModel(ds.Tables[0], 0)); } else { return(null); } }
//数据绑定 void Bind() { int gid = Str2Int(q("id"), 0); Daiv_OA.Entity.MechanicalEntity model = new Daiv_OA.Entity.MechanicalEntity(); model = new Daiv_OA.BLL.MechanicalBLL().GetEntity(gid); this.MechIMEI.Text = model.MechIMEI; this.MechName.Text = model.MechName; this.MechPhone.Text = model.MechPhone; //string sql = ""; //Daiv_OA.BLL.GradeBLL dp = new Daiv_OA.BLL.GradeBLL(); //DataSet ds = dp.GetList(sql); //for (int j = 0; j < ds.Tables[0].Rows.Count; j++) //{ // ListItem listItem = new ListItem(); // listItem.Text = ds.Tables[0].Rows[j]["Gname"].ToString(); // listItem.Value = ds.Tables[0].Rows[j]["Gid"].ToString(); // this.ddlGid.Items.Add(listItem); //} //this.ddlGid.SelectedValue = model.Gid.ToString(); //ds.Clear(); }