public static Assembly TCar(string title, string subtitle, object properties)
{
var source = "R:2.0:S1;R:3.5:S2;R:5.0:S3;R:6.5:S4;";
var destination = "L:2.0:D1;L:3.5:D2;L:5.0:D3;L:6.5:D4;";
TCarInfo info = new TCarInfo
{
TCarLength = 5.0f,
TCarWidth = 1.25f,
ConveyorWidth = 0.972f,
height = 0.7f,
Source = source,
Destination = destination,
};
return(new TCar(info));
}
public static int AddCarInfo(SqlConnection con, SqlTransaction sqr, ref TCarInfo ci)
{
String sql = String.Empty;
try
{
sql = "Insert into tCarInfo(CarName,CarNumber,CarTrevalDistance,CarComeTime,CarOwner,CarOwnerTel1,CarOwnerTel2,OprtUserCode)" +
"values(@CarName,@CarNumber,@CarTrevalDistance,@CarComeTime,@CarOwner,@CarOwnerTel1,@CarOwnerTel2,@OprtUserCode)";
Int32 CarID = 0;
SqlParameter[] pms = new SqlParameter[] {
new SqlParameter("@CarName",ci.CarName),
new SqlParameter("@CarNumber",ci.CarNumber),
new SqlParameter("@CarTrevalDistance",ci.CarTrevalDistance),
new SqlParameter("@CarComeTime",ci.CarComeTime),
new SqlParameter("@CarOwner",ci.CarOwner),
new SqlParameter("@CarOwnerTel1",ci.CarOwnerTel1),
new SqlParameter("@CarOwnerTel2",ci.CarOwnerTel2),
new SqlParameter("@OprtUserCode",ci.OprtUserCode)
};
if (MsSqlHelper.ExecSqlUControl(con, sqr, sql, pms) == 1)
{
CarID = Convert.ToInt32(MsSqlHelper.GetSingle(con, sqr, "select max(CarID) as CarID from tCarInfo where OprtUserCode=@OprtUserCode",
new SqlParameter("@OprtUserCode", ci.OprtUserCode)));
ci.CarID = CarID;
return 1;
}
else
{
return 0;
}
}
catch(Exception e)
{
LogHelper.WriteLog("AddCarInfo", e);
return 0;
}
}
public static int AddTask(ref TTaskInfo ti, ref TCarInfo ci)
{
SqlConnection con = new SqlConnection(MsSqlHelper.connectionString);
con.Open();
SqlTransaction st = con.BeginTransaction();
try
{
if (TCarInfoDAL.AddCarInfo(con, st, ref ci) == 1)
{
ti.CarID = ci.CarID;
if (TTaskInfoDAL.AddTask(con, st, ref ti) == 1)
{
st.Commit();
return(1);
}
else
{
throw new Exception("添加任务信息出错");
}
}
else
{
throw new Exception("添加车辆信息出错");
}
}
catch (Exception e)
{
LogHelper.WriteLog("TTaskInfoDAL.AddTask 2", e);
st.Rollback();
con.Close();
con.Dispose();
return(0);
}
}
public TGeneration(int Begin, int End)
{
this.GenBegin = Begin;
this.GenEnd = End;
CurrCar = new TCarInfo();
}
public static int AddTask(string carNo, string MaintainTypes, string technicians, string carName,
string carOwner, string carOwnerTel1, string carOwnerTel2, string carTrevalDistance, string OprtUserCode
)
{
try
{
DateTime dt = DateTime.Now;
TCarInfo tCi = new TCarInfo();
tCi.CarID = 0;
tCi.CarNumber = carNo;
tCi.CarName = carName;
tCi.CarOwner = carOwner;
tCi.CarOwnerTel1 = carOwnerTel1;
tCi.CarOwnerTel2 = carOwnerTel2;
if (carTrevalDistance != null && carTrevalDistance != String.Empty)
{
tCi.CarTrevalDistance = int.Parse(carTrevalDistance);
}
tCi.CarComeTime = dt;
tCi.OprtUserCode = OprtUserCode;
TTaskInfo tTi = new TTaskInfo();
tTi.TaskID = 0;
tTi.CarID = 0;
tTi.BeginDate = dt;
tTi.OprtUserCode = OprtUserCode;
tTi.ListItems = new List <TTaskItem>();
if (MaintainTypes != String.Empty)
{
String[] mtTypes = MaintainTypes.Split(',');
for (int i = 0; i < mtTypes.Length; i++)
{
//分配维修师傅
List <TTaskItemWorkers> listTw = new List <TTaskItemWorkers>();
if (technicians != String.Empty)
{
//获取可进行该维修类别的所有维修师傅ID列表
List <int> listmt = TUserInfoBLL.UGetMaintainUsers(int.Parse(mtTypes[i]));
String[] tns = technicians.Split(',');
foreach (var item in tns)
{
//判断循环中当前维修师傅，是否在上面的列表中
if (listmt.Contains(int.Parse(item)))
{
listTw.Add(new TTaskItemWorkers()
{
TaskID = 0,
TaskItemID = 0,
UID = int.Parse(item)
});
}
}
}
tTi.ListItems.Add(new TTaskItem()
{
TaskID = 0,
MID = int.Parse(mtTypes[i]),
TaskItemID = i,
BeginTime = dt,
ListWorks = listTw
}
);
}
}
return(TTaskInfoBLL.AddTask(ref tTi, ref tCi));
}
catch (Exception e)
{
LogHelper.WriteLog("AddTask", e);
return(0);
}
}
public static int AddTask(ref TTaskInfo ti, ref TCarInfo ci)
{
return(TTaskInfoDAL.AddTask(ref ti, ref ci));
}
