//获取司机列表
public XmlDocument getDriverList()
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getDriverList");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//获取有出车天数的车牌
public XmlDocument getCarListOnDesc(string _licenseidList)
{
result = XmlProvider.Document("sqldata");
string _sql = " SELECT SUM(CAST(DAYS as int)) AS DAYS ,LicenseID FROM CAR_APPLIED WHERE AppliedStatue!='拒绝' and AppliedStatue!='取消' AND LicenseID!='NULL' AND " + _licenseidList + " group by licenseid order by DAYS ASC";
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
this.result = SQLProvider.GetData(_cmd);
}
return(result);
}
//获取有出车天数的车牌
public string getApplyCount(string _SqlLicenseID, DateTime _SqlStart, DateTime _SqlEnd)
{
result = XmlProvider.Document("sqldata");
string _sql = "Select Count(*) AS NUM from Car_Applied where licenseid='" + _SqlLicenseID + "' and StartTime>='" + _SqlStart.ToString() + "' and StartTime<='" + _SqlEnd.ToString() + "'";
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
this.result = SQLProvider.GetData(_cmd);
}
return(result.DocumentElement.SelectSingleNode("SchemaTable/Num").InnerText.ToString().Trim());
}
/// <summary>
/// 查询所有车辆状态为出行、维修、空闲的车辆的车牌集合
/// </summary>
/// <returns></returns>
public XmlDocument getEnableCarLicense()
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getEnableCarLicense");//Car.xml中的获取所有车辆状态为出行、维修、空闲的车辆的车牌的标签的type为 getEnableCarLicense
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
this.result = SQLProvider.GetData(_cmd);
}
return(result);
}
//获取需要调度员控制的车辆数量
public int getControlNum()
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getControlCarNum");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
result = SQLProvider.GetData(_cmd);
}
return(Convert.ToInt32(result.DocumentElement.SelectSingleNode("SchemaTable/SetValue").InnerText.ToString().Trim()));
}
//获取司机详情
public XmlDocument getDriverDetail(string _driverid)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getDriverDetail");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter driverid = new SqlParameter("DriverID", SqlDbType.NVarChar, 50);
driverid.Value = _driverid;
_cmd.Parameters.Add(driverid);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//根据账号查找司机信息
public XmlDocument getSingleDetailByAccount(string _account)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getByAccount");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter account = new SqlParameter("DriverAccount", SqlDbType.NVarChar, 50);
account.Value = _account;
_cmd.Parameters.Add(account);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//获取待联系方式的车辆记录
public XmlDocument getSingleCarAndCarTel(string _guid)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getSingleCarAndCarTel");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter guid = new SqlParameter("Guid", SqlDbType.NVarChar, 50);
guid.Value = _guid;
_cmd.Parameters.Add(guid);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
/// <summary>
/// 查询临时调度员账号
/// </summary>
/// <returns></returns>
public XmlDocument getLsDispatcher()
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getLsDispather");//Dispather.xml中的获取临时调度员账号的标签的type为getLsDispather
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter resourceID = new SqlParameter("ResourceID", SqlDbType.NVarChar, 50);
resourceID.Value = "LSSYSTEM";
_cmd.Parameters.Add(resourceID);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//获取待联系方式的车辆记录ByLicenseID
public XmlDocument getSingleCarByLicenseID(string _licenseID)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getSingleCarByLicenseID");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
licenseID.Value = _licenseID;
_cmd.Parameters.Add(licenseID);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//解除司机与车辆绑定
public XmlDocument unBound(string _licenseID)
{
result = XmlProvider.Document("data");
string _sql = readXml("unBound");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
licenseID.Value = _licenseID;
_cmd.Parameters.Add(licenseID);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
//更新需要调度员控制的车辆数量
public XmlDocument upControlNum(int _num)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("upControlCarNum");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter SetValue = new SqlParameter("SetValue", SqlDbType.NVarChar, 50);
SetValue.Value = _num;
_cmd.Parameters.Add(SetValue);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
/// <summary>
/// 获取车辆状态
/// </summary>
/// <param name="_reqLicenseID"></param>
/// <returns></returns>
public string getStatue(string _reqLicenseID)
{
this.result = XmlProvider.Document("sqldata");
string _sql = readXml("getCarStatue");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
licenseID.Value = _reqLicenseID;
_cmd.Parameters.Add(licenseID);
result = SQLProvider.GetData(_cmd);
}
return(this.result.DocumentElement.SelectSingleNode("SchemaTable/CarStatue").InnerText.ToString().Trim());//车辆状态
}
/// <summary>
/// 删除司机
/// </summary>
/// <param name="_driverID"></param>
/// <returns></returns>
public XmlDocument delDriver(string _driverID)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("delDriver");//driver.xml中的添加车辆的标签的type为addDriver
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter driverID = new SqlParameter("DriverID", SqlDbType.NVarChar, 50);
driverID.Value = _driverID;
_cmd.Parameters.Add(driverID);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
//司机获取列表
public XmlDocument getListD(string _account)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("getListD");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _coAccount = new SqlParameter("COAccount", SqlDbType.NVarChar, 50);
_coAccount.Value = _account;
_cmd.Parameters.Add(_coAccount);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
//更新车牌
public XmlDocument upLicense(string _driverid, string _licenseid)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("upLicense");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter driverid = new SqlParameter("DriverID", SqlDbType.NVarChar, 50);
driverid.Value = _driverid;
_cmd.Parameters.Add(driverid);
SqlParameter licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
licenseID.Value = _licenseid;
_cmd.Parameters.Add(licenseID);
result = SQLProvider.Transcation(_cmd);
}
return(this.result);
}
/// <summary>
/// 更新车辆状态
/// </summary>
/// <param name="_licenseID">车牌</param>
/// <returns></returns>
public XmlDocument upCarStatue(string _guid, string _carStatue)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("upCarStatue");//Car.xml中的更新车辆状态的标签的type为upCarStatue
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter carStatue = new SqlParameter("CarStatue", SqlDbType.NVarChar, 50);
carStatue.Value = _carStatue;
_cmd.Parameters.Add(carStatue);
SqlParameter guid = new SqlParameter("Guid", SqlDbType.NVarChar, 50);
guid.Value = _guid;
_cmd.Parameters.Add(guid);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
//更新总公里数
public XmlDocument upKm(string _km, string _account)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("upKm");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _diAccount = new SqlParameter("DriverAccount", SqlDbType.NVarChar, 50);
_diAccount.Value = _account;
_cmd.Parameters.Add(_diAccount);
SqlParameter _kmLength = new SqlParameter("Kilometers", SqlDbType.NVarChar, 50);
_kmLength.Value = _km;
_cmd.Parameters.Add(_kmLength);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
//根据ID查找某一预约信息
public XmlDocument getApply(string _guid)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("getApply");
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _applyID = new SqlParameter("CarAppliedID", SqlDbType.NVarChar, 50);
_applyID.Value = _guid;
_cmd.Parameters.Add(_applyID);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
public XmlDocument upCarStatueByLicenseID(string _licenseID, string _carStatue)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("upCarStatueByLicenseID");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter carStatue = new SqlParameter("CarStatue", SqlDbType.NVarChar, 50);
carStatue.Value = _carStatue;
_cmd.Parameters.Add(carStatue);
SqlParameter guid = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
guid.Value = _licenseID;
_cmd.Parameters.Add(guid);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
/// <summary>
/// 车辆维修列表
/// </summary>
/// <returns></returns>
public XmlDocument getFixedList()
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getFixdList");
try
{
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
result = SQLProvider.GetData(_cmd);
}
}
catch (Exception _exc)
{
Provider.LogErr(result, _exc);
}
return(result);
}
/// <summary>
/// 添加维修记录
/// </summary>
/// <param name="_reqLisenceID">车牌</param>
/// <param name="_reqStartTime">开始时间</param>
/// <param name="_reqEndTime">结束时间</param>
/// <returns></returns>
public XmlDocument addFixed(string _reqLicenseID, string _reqStartTime, string _reqEndTime)
{
DateTime _reqEndTimeDay = Convert.ToDateTime(_reqEndTime);
_reqEndTime = _reqEndTimeDay.Year + "-" + _reqEndTimeDay.Month + "-" + _reqEndTimeDay.Day + " 23:59:59";
result = XmlProvider.Document("configdata");
string _sql = readXml("addFixed");
try
{
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _guid = new SqlParameter("FixID", SqlDbType.NVarChar, 50);
_guid.Value = Provider.GUID;
_cmd.Parameters.Add(_guid);
SqlParameter _licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
_licenseID.Value = _reqLicenseID;
_cmd.Parameters.Add(_licenseID);
SqlParameter _startTime = new SqlParameter("StartTime", SqlDbType.NVarChar, 50);
_startTime.Value = Convert.ToDateTime(_reqStartTime);
_cmd.Parameters.Add(_startTime);
SqlParameter _endTime = new SqlParameter("EndTime", SqlDbType.NVarChar, 50);
_endTime.Value = Convert.ToDateTime(_reqEndTime);
_cmd.Parameters.Add(_endTime);
SqlParameter _statue = new SqlParameter("Statue", SqlDbType.NVarChar, 10);
_statue.Value = "未开始";
_cmd.Parameters.Add(_statue);
result = SQLProvider.Transcation(_cmd);
}
}
catch (Exception _exc)
{
Provider.LogErr(result, _exc);
}
return(result);
}
private XmlDocument TokenData()
{
XmlDocument _result = XmlProvider.Document("sqldata");
try
{
//获取用户
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = "select top 1 * from V_Token where TokenID=@id";
SqlParameter _id = new SqlParameter("id", SqlDbType.NVarChar, 50);
_id.Value = this.token;
_cmd.Parameters.Add(_id);
_result = SQLProvider.GetData(_cmd);
//XmlDocument _api = XmlProvider.Document("api");
//_api.Load("http://api.qgj.cn/webapi/profile.asmx/GetUser?User="******"SchemaTable/TokenAccount").InnerText.Trim());
//设置用户名
XmlElement _name = _result.CreateElement("TokenName");
GetUserInfo user = new GetUserInfo(_result.DocumentElement.SelectSingleNode("SchemaTable/TokenAccount").InnerText.Trim());
_name.InnerXml = "<![CDATA[" + user.getUserName() + "]]>";
_result.DocumentElement.SelectSingleNode("SchemaTable").AppendChild(_name);
//设置权限节点
XmlElement _realPermit = _result.CreateElement("TokenPermit");
_realPermit.InnerXml = "<![CDATA[ ]]>";
_result.DocumentElement.SelectSingleNode("SchemaTable").AppendChild(_realPermit);
}
}
catch (Exception _exc)
{
Provider.LogErr(_result, _exc);
}
return(_result);
}
//查找某车某天冲突记录(id)
public XmlDocument clashApply(string _delayLicenseid, DateTime _dalyStarTtime)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("delayClashApply");
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _licenseid = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
_licenseid.Value = _delayLicenseid;
_cmd.Parameters.Add(_licenseid);
SqlParameter _starttime = new SqlParameter("StartTime", SqlDbType.NVarChar, 50);
_starttime.Value = _dalyStarTtime;
_cmd.Parameters.Add(_starttime);
result = SQLProvider.GetData(_cmd);
}
return(result);
}
//更改预约状态
public XmlDocument upApplyStatue(string _guid, string _statue)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("upApplyStatue");
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _applyID = new SqlParameter("CarAppliedID", SqlDbType.NVarChar, 50);
_applyID.Value = _guid;
_cmd.Parameters.Add(_applyID);
SqlParameter _statues = new SqlParameter("AppliedStatue", SqlDbType.NVarChar, 50);
_statues.Value = _statue;
_cmd.Parameters.Add(_statues);
result = SQLProvider.Transcation(_cmd);
}
return(this.result);
}
//派遣司机
public XmlDocument sendDriver(string _guid, string _account, string _name, string _linceseid, string _tel)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("sendDriver");
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _licenid = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
_licenid.Value = _linceseid;
_cmd.Parameters.Add(_licenid);
SqlParameter _owner = new SqlParameter("CarOwner", SqlDbType.NVarChar, 50);
_owner.Value = _name;
_cmd.Parameters.Add(_owner);
SqlParameter _coAccount = new SqlParameter("COAccount", SqlDbType.NVarChar, 50);
_coAccount.Value = _account;
_cmd.Parameters.Add(_coAccount);
SqlParameter _carTel = new SqlParameter("CarTelephone", SqlDbType.NVarChar, 50);
_carTel.Value = _tel;
_cmd.Parameters.Add(_carTel);
SqlParameter _guids = new SqlParameter("CarAppliedID", SqlDbType.NVarChar, 50);
_guids.Value = _guid;
_cmd.Parameters.Add(_guids);
result = SQLProvider.Transcation(_cmd);
}
return(this.result);
}
/// <summary>
/// 修改车辆
/// </summary>
public XmlDocument motifyCar(string _guid, string _licenseID, string _driverAccount, string _sites, string _mot, string _insurance, string _kilometers)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("motifyCar");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter guid = new SqlParameter("Guid", SqlDbType.NVarChar, 50);
guid.Value = _guid;
_cmd.Parameters.Add(guid);
SqlParameter licenseID = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
licenseID.Value = _licenseID;
_cmd.Parameters.Add(licenseID);
SqlParameter driverAccount = new SqlParameter("DriverAccount", SqlDbType.NVarChar, 50);
driverAccount.Value = _driverAccount;
_cmd.Parameters.Add(driverAccount);
SqlParameter sites = new SqlParameter("Sites", SqlDbType.Int);
sites.Value = Convert.ToInt32(_sites);
_cmd.Parameters.Add(sites);
SqlParameter mot = new SqlParameter("MOT", SqlDbType.NVarChar, 50);
mot.Value = _mot;
_cmd.Parameters.Add(mot);
SqlParameter insurance = new SqlParameter("Insurance", SqlDbType.NVarChar, 50);
insurance.Value = _insurance;
_cmd.Parameters.Add(insurance);
SqlParameter kilometers = new SqlParameter("Kilometers", SqlDbType.NVarChar, 50);
kilometers.Value = _kilometers;
_cmd.Parameters.Add(kilometers);
result = SQLProvider.Transcation(_cmd);
}
return(result);
}
//获取部门领导账号
public string getDepartAccount(string _departID)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("getDepartLeader");
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter departID = new SqlParameter("DepartID", SqlDbType.NVarChar, 50);
departID.Value = _departID;
_cmd.Parameters.Add(departID);
result = SQLProvider.GetData(_cmd);
}
if (result.DocumentElement.SelectNodes("SchemaTable").Count > 0)
{
return(result.DocumentElement.SelectSingleNode("SchemaTable/DepartLeaderAccount").InnerText.ToString().Trim());
}
else
{
return("");
}
}
//查找某车某日记录
public XmlDocument getDayCar(string _reqLicenseID, string _stime)
{
result = XmlProvider.Document("sqldata");
string _sql = readXml("getDayCar");
DateTime _stimeDate = Convert.ToDateTime(_stime);
//读取数据
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _licenseid = new SqlParameter("LicenseID", SqlDbType.NVarChar, 50);
_licenseid.Value = _reqLicenseID;
_cmd.Parameters.Add(_licenseid);
SqlParameter _starttime = new SqlParameter("starttime", SqlDbType.NVarChar, 50);
_starttime.Value = _stimeDate.Year + "-" + _stimeDate.Month + "-" + _stimeDate.Day + " 23:00:00";
_cmd.Parameters.Add(_starttime);
result = SQLProvider.GetData(_cmd);
}
return(this.result);
}
/// <summary>
/// 取消维修
/// </summary>
/// <param name="_reqFixID"></param>
/// <returns></returns>
public XmlDocument cancelFixedStatue(string _reqFixID)
{
result = XmlProvider.Document("configdata");
string _sql = readXml("cancelFixedStatue");
try
{
using (SqlCommand _cmd = new SqlCommand())
{
_cmd.Connection = SQLConfig.Connection(this.conn);
_cmd.CommandText = _sql;
SqlParameter _guid = new SqlParameter("FixID", SqlDbType.NVarChar, 50);
_guid.Value = _reqFixID;
_cmd.Parameters.Add(_guid);
result = SQLProvider.Transcation(_cmd);
}
}
catch (Exception _exc)
{
Provider.LogErr(result, _exc);
}
return(this.result);
}