/// <summary> /// 添加信息联系人(使用事务控制) /// </summary> public bool InsertContactMan(SqlConnection sqlConn, SqlTransaction sqlTran, Tz888.Model.Info.InfoContactManModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ContactManID", SqlDbType.BigInt, 8), new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Mobile", SqlDbType.VarChar, 30), new SqlParameter("@Remark", SqlDbType.VarChar, 100) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.InfoID; parameters[2].Value = model.Name; parameters[3].Value = model.Mobile; parameters[4].Value = model.Remark; DbHelperSQL.RunProcedure(sqlConn, sqlTran, SP_InfoContactMan_Insert, parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } return(false); }
/// <summary> /// 获取指定资源ID的所有联系人信息 /// </summary> /// <param name="InfoID"></param> /// <returns></returns> public List <Tz888.Model.Info.InfoContactManModel> GetModelList(long InfoID) { List <Tz888.Model.Info.InfoContactManModel> lists = new List <InfoContactManModel>(); SqlParameter[] parameters = { new SqlParameter("@InfoID", SqlDbType.BigInt, 8) }; parameters[0].Value = InfoID; DataSet ds = DbHelperSQL.RunProcedure("InfoContactManTab_GetListByInfoID", parameters, "ds"); if (ds == null || ds.Tables[0].Rows.Count == 0) { return(null); } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Tz888.Model.Info.InfoContactManModel model = new Tz888.Model.Info.InfoContactManModel(); model.InfoID = InfoID; if (ds.Tables[0].Rows[i]["ContactManID"].ToString() != "") { model.ContactManID = Convert.ToInt64(ds.Tables[0].Rows[0]["ContactManID"]); } model.Name = ds.Tables[0].Rows[i]["Name"].ToString(); model.Mobile = ds.Tables[0].Rows[i]["Mobile"].ToString(); model.Remark = ds.Tables[0].Rows[i]["Remark"].ToString(); lists.Add(model); } return(lists); }