public static bool UpdateWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac)
{
string sql = @"UPDATE Configuration..WheelAdapterConfigWithTid
SET PCD=@pcd,
ET=@et,
MinET=@minet,
MaxET=@maxet,
CB=@cb,
BoltNutSpec=@boltnutspec,
BoltNut=@boltnut,
MinWheelSize=@minwheelsize,
MaxWheelSize=@maxwheelsize,
MinWheelWidth=@minwheelwidth,
MaxWheelWidth=@maxwheelwidth,
LastUpdateDateTime=@lastupdatedatetime
WHERE TID=@tid";
var sqlParam = new[]
{
new SqlParameter("@tid", wac.TID),
new SqlParameter("@pcd", wac.PCD),
new SqlParameter("@et", wac.ET),
new SqlParameter("@minet", wac.MinET),
new SqlParameter("@maxet", wac.MaxET),
new SqlParameter("@cb", wac.CB),
new SqlParameter("@boltnutspec", wac.BoltNutSpec),
new SqlParameter("@boltnut", wac.BoltNut),
new SqlParameter("@minwheelsize", wac.MinWheelSize),
new SqlParameter("@maxwheelsize", wac.MaxWheelSize),
new SqlParameter("@minwheelwidth", wac.MinWheelWidth),
new SqlParameter("@maxwheelwidth", wac.MaxWheelWidth),
new SqlParameter("@lastupdatedatetime", wac.LastUpdateDateTime),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false);
}
public static bool InsertWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac)
{
string sql = @"INSERT INTO Configuration..WheelAdapterConfigWithTid
(TID,PCD,ET,MinET,MaxET,CB,BoltNutSpec,BoltNut,MinWheelSize,MaxWheelSize,
MinWheelWidth,MaxWheelWidth,CreateDateTime,LastUpdateDateTime,Creator)
VALUES(@tid,@pcd,@et,@minet,@maxet,@cb,@boltnutspec,@boltnut,@minwheelsize,@maxwheelsize,
@minwheelwidth,@maxwheelwidth,@createdatetime,@lastupdatedatetime,@creator)";
var sqlParam = new[]
{
new SqlParameter("@tid", wac.TID),
new SqlParameter("@pcd", wac.PCD),
new SqlParameter("@et", wac.ET),
new SqlParameter("@minet", wac.MinET),
new SqlParameter("@maxet", wac.MaxET),
new SqlParameter("@cb", wac.CB),
new SqlParameter("@boltnutspec", wac.BoltNutSpec),
new SqlParameter("@boltnut", wac.BoltNut),
new SqlParameter("@minwheelsize", wac.MinWheelSize),
new SqlParameter("@maxwheelsize", wac.MaxWheelSize),
new SqlParameter("@minwheelwidth", wac.MinWheelWidth),
new SqlParameter("@maxwheelwidth", wac.MaxWheelWidth),
new SqlParameter("@createdatetime", wac.CreateDateTime),
new SqlParameter("@lastupdatedatetime", wac.LastUpdateDateTime),
new SqlParameter("@creator", wac.Creator),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam) > 0 ? true : false);
}
public JsonResult BatchSaveWheelAdapterConfig(WheelAdapterConfigWithTid wac, IEnumerable <string> tids)
{
var props = typeof(WheelAdapterConfigWithTid).GetProperties();
wac.CreateDateTime = DateTime.Now;
wac.LastUpdateDateTime = DateTime.Now;
wac.Creator = ThreadIdentity.Operator.Name;
var result = WheelAdapterConfigManager.InsertWheelAdapterConfigWithTid(wac, tids);
return(Json(result));
}
public ActionResult WheelAdapterEditModule(string tid)
{
List <WheelAdapterConfigWithTid> waclist = WheelAdapterConfigManager.SelectWheelAdapterConfigWithTid(tid);
WheelAdapterConfigWithTid wac = new WheelAdapterConfigWithTid();
if (waclist.Count > 0)
{
wac = waclist[0];
}
else
{
wac.PKId = 0;
wac.TID = tid;
}
return(View(wac));
}
public bool UpdateWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac)
{
try
{
return(handler.UpdateWheelAdapterConfigWithTid(wac));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "UpdateWheelAdapterConfigWithTid", ex);
Logger.Log(Level.Error, exception, "UpdateWheelAdapterConfigWithTid");
throw ex;
}
}
public bool InsertWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac, IEnumerable <string> tids)
{
try
{
return(handler.InsertWheelAdapterConfigWithTid(wac, tids));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "InsertWheelAdapterConfigWithTid", ex);
Logger.Log(Level.Error, exception, "InsertWheelAdapterConfigWithTid");
throw ex;
}
}
public JsonResult SaveWheelAdapterConfig(WheelAdapterConfigWithTid wac)
{
bool flag = false;
if (wac.PKId == 0)
{
wac.CreateDateTime = DateTime.Now;
wac.LastUpdateDateTime = DateTime.Now;
wac.Creator = ThreadIdentity.Operator.Name;
flag = WheelAdapterConfigManager.InsertWheelAdapterConfigWithTid(wac);
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = wac.TID,
OperateType = 0,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl);
}
else
{
wac.LastUpdateDateTime = DateTime.Now;
flag = WheelAdapterConfigManager.UpdateWheelAdapterConfigWithTid(wac);
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = wac.TID,
OperateType = 1,
CreateDateTime = DateTime.Now,
LastUpdateDateTime = DateTime.Now,
Operator = ThreadIdentity.Operator.Name,
};
bool flag1 = WheelAdapterConfigManager.InsertWheelAdapterConfigLog(wacl);
}
if (flag)
{
RefreshCache(new List <string>()
{
wac.TID
});
}
return(Json(flag));
}
public bool UpdateWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac)
{
Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.UpdateWheelAdapterConfigWithTid(connection, wac);
return(dbManager.Execute(action));
}
public bool InsertWheelAdapterConfigWithTid(WheelAdapterConfigWithTid wac, IEnumerable <string> tids)
{
Func <SqlConnection, bool> action = (connection) => DalWheelAdapterConfig.InsertWheelAdapterConfigWithTid(connection, wac, tids);
return(dbManager.Execute(action));
}
public static bool InsertWheelAdapterConfigWithTid(SqlConnection conn, WheelAdapterConfigWithTid wac, IEnumerable <string> tids)
{
bool result = true;
var props = typeof(WheelAdapterConfigWithTid).GetProperties();
var getresults = SelectWheelAdapterConfigWithTid(conn, tids);
if (getresults != null && getresults.Any())
{
foreach (var item in getresults)
{
foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime?) &&
!string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase) &&
!string.Equals(x.Name, "tid", StringComparison.OrdinalIgnoreCase)
))
{
var value = propertyInfo.GetValue(wac);
if (value != null)
{
propertyInfo.SetValue(item, value);
}
}
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = item.TID,
OperateType = 1,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
InsertWheelAdapterConfigLog(conn, wacl);
item.LastUpdateDateTime = DateTime.Now;
item.Creator = wac.Creator;
result &= UpdateWheelAdapterConfigWithTid(conn, item);
}
}
var notgetitems = tids.Except(getresults.Select(x => x.TID)).Select(x =>
{
var item = JsonConvert.DeserializeObject <WheelAdapterConfigWithTid>(JsonConvert.SerializeObject(wac));
item.TID = x;
return(item);
});
foreach (var item in notgetitems)
{
WheelAdapterConfigLog wacl = new WheelAdapterConfigLog()
{
TID = item.TID,
OperateType = 0,
CreateDateTime = wac.CreateDateTime,
LastUpdateDateTime = wac.LastUpdateDateTime,
Operator = wac.Creator,
};
InsertWheelAdapterConfigLog(conn, wacl);
result &= InsertWheelAdapterConfigWithTid(conn, item);
}
return(result);
//string sql = "";
//var sqlParam = new List<SqlParameter>();
//var props = typeof(WheelAdapterConfigWithTid).GetProperties();
//List<string> insertsqls = new List<string>();
//foreach (var propertyInfo in props.Where(x => x.PropertyType != typeof(DateTime) && !string.Equals(x.Name, "pkid", StringComparison.OrdinalIgnoreCase)))
//{
//}
//var records = new List<SqlDataRecord>(tids.Count());
//foreach (var target in tids)
//{
// var record = new SqlDataRecord(new SqlMetaData("Pid", SqlDbType.Char, 40));
// var chars = new SqlChars(target.ToString());
// record.SetSqlChars(0, chars);
// records.Add(record);
//}
//using (var cmd = new SqlCommand(sql))
//{
// cmd.CommandType = CommandType.Text;
// SqlParameter p = new SqlParameter("@TVP", SqlDbType.Structured);
// p.TypeName = "dbo.Pids";
// p.Value = records;
// sqlParam.Add(p);
// //return await dbhelper.ExecuteNonQueryAsync(cmd);
// return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParam.ToArray()) > 0;
//}
}
