/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.Common.Tb_Common_TelList GetModel(long InfoId) { SqlParameter[] parameters = { new SqlParameter("@InfoId", SqlDbType.BigInt) }; parameters[0].Value = InfoId; MobileSoft.Model.Common.Tb_Common_TelList model = new MobileSoft.Model.Common.Tb_Common_TelList(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Common_TelList_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["InfoId"].ToString() != "") { model.InfoId = long.Parse(ds.Tables[0].Rows[0]["InfoId"].ToString()); } model.UserCode = ds.Tables[0].Rows[0]["UserCode"].ToString(); model.TelNum = ds.Tables[0].Rows[0]["TelNum"].ToString(); model.Mark = ds.Tables[0].Rows[0]["Mark"].ToString(); model.Duty = ds.Tables[0].Rows[0]["Duty"].ToString(); if (ds.Tables[0].Rows[0]["Sort"].ToString() != "") { model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString()); } model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString(); model.Mail = ds.Tables[0].Rows[0]["Mail"].ToString(); model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString(); model.CommName = ds.Tables[0].Rows[0]["CommName"].ToString(); model.OprName = ds.Tables[0].Rows[0]["OprName"].ToString(); if (ds.Tables[0].Rows[0]["CompanyNameSort"].ToString() != "") { model.CompanyNameSort = int.Parse(ds.Tables[0].Rows[0]["CompanyNameSort"].ToString()); } if (ds.Tables[0].Rows[0]["CommNameSort"].ToString() != "") { model.CommNameSort = int.Parse(ds.Tables[0].Rows[0]["CommNameSort"].ToString()); } if (ds.Tables[0].Rows[0]["DutySort"].ToString() != "") { model.DutySort = int.Parse(ds.Tables[0].Rows[0]["DutySort"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(MobileSoft.Model.Common.Tb_Common_TelList model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@InfoId", SqlDbType.BigInt, 8), new SqlParameter("@UserCode", SqlDbType.NVarChar, 255), new SqlParameter("@TelNum", SqlDbType.NVarChar, 255), new SqlParameter("@Mark", SqlDbType.NVarChar, 255), new SqlParameter("@Duty", SqlDbType.NVarChar, 255), new SqlParameter("@Sort", SqlDbType.Int, 4), new SqlParameter("@Phone", SqlDbType.NVarChar, 255), new SqlParameter("@Mail", SqlDbType.NVarChar, 50), new SqlParameter("@CompanyName", SqlDbType.NVarChar, 255), new SqlParameter("@CommName", SqlDbType.NVarChar, 255), new SqlParameter("@OprName", SqlDbType.NVarChar, 255), new SqlParameter("@CompanyNameSort", SqlDbType.Int, 4), new SqlParameter("@CommNameSort", SqlDbType.Int, 4), new SqlParameter("@DutySort", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.UserCode; parameters[2].Value = model.TelNum; parameters[3].Value = model.Mark; parameters[4].Value = model.Duty; parameters[5].Value = model.Sort; parameters[6].Value = model.Phone; parameters[7].Value = model.Mail; parameters[8].Value = model.CompanyName; parameters[9].Value = model.CommName; parameters[10].Value = model.OprName; parameters[11].Value = model.CompanyNameSort; parameters[12].Value = model.CommNameSort; parameters[13].Value = model.DutySort; DbHelperSQL.RunProcedure("Proc_Tb_Common_TelList_ADD", parameters, out rowsAffected); return((long)parameters[0].Value); }