public List<DicReader> GetPlistVisitingLogTrs(string key, DateTime? leftVisitOn, DateTime? rightVisitOn, PagingInput paging)
{
paging.Valid();
if (key != null)
{
key = key.Trim();
}
Func<SqlFilter> filter = () =>
{
var parameters = new List<DbParameter>();
var filterString = @" where a.LoginName like @key ";
parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String));
if (leftVisitOn.HasValue)
{
parameters.Add(CreateParameter("leftVisitOn", leftVisitOn.Value, DbType.DateTime));
filterString += " and a.VisitOn>=@leftVisitOn";
}
if (rightVisitOn.HasValue)
{
parameters.Add(CreateParameter("rightVisitOn", rightVisitOn.Value, DbType.DateTime));
filterString += " and a.VisitOn<@rightVisitOn";
}
return new SqlFilter(filterString, parameters.ToArray());
};
return base.GetPlist("VisitingLog", filter, paging);
}
public Category[] GetAllCategories()
{
List<Category> myCategories = new List<Category>();
SqlConnection myConn = new SqlConnection(connstring);
myConn.Open();
SqlCommand mySqlCommand = new SqlCommand("select * from Category", myConn);
SqlDataReader reader = mySqlCommand.ExecuteReader();
while (reader.Read())
{
Category myCategory = new Category();
object id = reader["Id"];
if (id != null)
{
int categoryId = -1;
if (!int.TryParse(id.ToString(), out categoryId))
{
throw new Exception("Failed to parse Id of video.");
}
myCategory.Id = categoryId;
}
myCategory.Name = reader["Name"].ToString();
myCategories.Add(myCategory);
}
myConn.Close();
return myCategories.ToArray();
}
static void InsertBatch()
{
Console.WriteLine("Inserting a bunch of trial data objects...");
var trialBatch = new List<Model.TrialData>();
var random = new Random();
var watch = new Stopwatch();
watch.Start();
for(int i=1; i<=50000; i++)
{
var parameters = new List<Parameter> {new Parameter { Name = "GBP.TotalReturnIndex", TrialNumber = 1, Value = random.NextDouble() },
new Parameter { Name = "USD.TotalReturnIndex", TrialNumber = 2, Value = random.NextDouble() },
new Parameter { Name = "EUR.TotalReturnIndex", TrialNumber = 3, Value = random.NextDouble() }};
var trialData = new TrialData { StressNumber = i, Parameters = parameters.ToArray() };
//var ravenConnection = new RavenConnection { ServerUrl = "http://localhost:8081/", DatabaseName = "TrialData" };
//Console.WriteLine("Inserting Stress {0}", i);
//var ravenDB = new RavenDB();
//var elapsed = ravenDB.PostTrialData(ravenConnection, trialData);
//Console.WriteLine("insert complete in {0}ms", elapsed);
trialBatch.Add(trialData);
}
var ravenConnection = new Model.RavenConnection { ServerUrl = "http://localhost:8081/", DatabaseName = "TrialData" };
var ravenDB = new RavenDB();
var elapsed = ravenDB.BulkInsertTrialData(ravenConnection, trialBatch);
watch.Stop();
//var elapsed = ravenDB.BulkInsertTrialDataEmbedded(ravenConnection, trialBatch);
Console.WriteLine();
Console.WriteLine("Operation complete in {0} minutes, {1} seconds and {2} milliseconds", watch.Elapsed.Minutes, watch.Elapsed.Seconds, watch.Elapsed.Milliseconds);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
ScrollViewer.SetVerticalScrollMode(CategoryPageGridView, ScrollMode.Disabled);
CategoryPageViewModel categoryPageViewModel =
(CategoryPageViewModel)Resources["CategoryPageViewModel"];
NavigationItem navigationItem = e.Parameter as NavigationItem;
var task = Task.Factory.StartNew(async () =>
{
var bundle = await DownloadNavigationItem(navigationItem.ReferralId);
var navigationItems = await DownloadNavigationItemsAsync();
await CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.High,
() =>
{
categoryPageViewModel.Content = bundle.Content[0];
var items = new List<Content>(bundle.Content);
items.RemoveAt(0);
bundle.Content = items.ToArray();
categoryPageViewModel.Bundle = bundle;
categoryPageViewModel.NavigationItems = navigationItems;
LoadingGrid.Visibility = Visibility.Collapsed;
MySplitView.Visibility = Visibility.Visible;
}
);
});
base.OnNavigatedTo(e);
}
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
HaParams returnValue = null;
var deserializationErrorMessage = "Could not read ha-params value";
if (reader.TokenType == JsonToken.Integer)
{
returnValue = new HaParams {AssociatedHaMode = HaMode.Exactly, ExactlyCount = (long)reader.Value};
}else if (reader.TokenType == JsonToken.StartArray)
{
var potentialReturnValue = new HaParams {AssociatedHaMode = HaMode.Nodes};
var nodesList = new List<string>();
do
{
reader.Read();
if (!new[] {JsonToken.EndArray, JsonToken.String}.Contains(reader.TokenType))
{
deserializationErrorMessage = "Could not read ha-params array value";
}
else if(reader.TokenType == JsonToken.String)
{
nodesList.Add(reader.Value as string);
}
} while (reader.TokenType == JsonToken.String);
potentialReturnValue.Nodes = nodesList.ToArray();
returnValue = potentialReturnValue;
}
if (returnValue != null)
{
return returnValue;
}
throw new JsonSerializationException(deserializationErrorMessage);
}
public List<DicReader> GetPlistCatalogAccountTrs(string key, string catalogCode
, bool includeDescendants, PagingInput paging)
{
paging.Valid();
if (string.IsNullOrEmpty(catalogCode))
{
throw new ArgumentNullException("catalogCode");
}
Func<SqlFilter> filter = () =>
{
var parameters = new List<DbParameter>();
var filterString = " where (a.Name like @key or a.Code like @key or a.LoginName like @key)";
parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String));
if (!includeDescendants)
{
parameters.Add(CreateParameter("CatalogCode", catalogCode, DbType.String));
filterString += " and a.CatalogCode=@CatalogCode";
}
else
{
parameters.Add(CreateParameter("CatalogCode", catalogCode + "%", DbType.String));
filterString += " and a.CatalogCode like @CatalogCode";
}
return new SqlFilter(filterString, parameters.ToArray());
};
return base.GetPlist("CatalogAccountTr", filter, paging);
}
public List<DicReader> GetPlistGroupAccountTrs(string key, Guid groupId, PagingInput paging)
{
paging.Valid();
Func<SqlFilter> filter = () =>
{
var parameters = new List<DbParameter>();
const string filterString = @" where (a.Name like @key
or a.Code like @key
or a.LoginName like @key) and a.GroupId=@GroupId";
parameters.Add(CreateParameter("key", "%" + key + "%", DbType.String));
parameters.Add(CreateParameter("GroupId", groupId, DbType.Guid));
return new SqlFilter(filterString, parameters.ToArray());
};
return base.GetPlist("GroupAccountTr", filter, paging);
}
public List<DicReader> GetPlistVisitingLogTrs(Guid accountId, string loginName, DateTime? leftVisitOn, DateTime? rightVisitOn, PagingInput paging)
{
paging.Valid();
loginName = (loginName ?? string.Empty).ToLower();
Func<SqlFilter> filter = () =>
{
var parameters = new List<DbParameter>();
var filterString = @" where (a.AccountId=@AccountId or Lower(a.LoginName)=@LoginName) ";
parameters.Add(CreateParameter("LoginName", loginName, DbType.String));
parameters.Add(CreateParameter("AccountId", accountId, DbType.Guid));
if (leftVisitOn.HasValue)
{
parameters.Add(CreateParameter("leftVisitOn", leftVisitOn.Value, DbType.DateTime));
filterString += " and a.VisitOn>=@leftVisitOn";
}
if (rightVisitOn.HasValue)
{
parameters.Add(CreateParameter("rightVisitOn", rightVisitOn.Value, DbType.DateTime));
filterString += " and a.VisitOn<@rightVisitOn";
}
return new SqlFilter(filterString, parameters.ToArray());
};
return base.GetPlist("VisitingLog", filter, paging);
}
void UCOldPartsPalautusManager_DeleteEvent(object sender, EventArgs e)
{
try
{
List<string> listField = new List<string>();
foreach (DataGridViewRow dr in dgvRData.Rows)
{
object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
if (isCheck != null && (bool)isCheck)
{
listField.Add(dr.Cells["return_id"].Value.ToString());
}
}
if (listField.Count == 0)
{
MessageBoxEx.Show("请选择删除记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
Dictionary<string, string> comField = new Dictionary<string, string>();
comField.Add("enable_flag", Convert.ToInt32(DataSources.EnumEnableFlag.DELETED).ToString());
comField.Add("update_by", HXCPcClient.GlobalStaticObj.UserID);//修改人Id
comField.Add("update_name", HXCPcClient.GlobalStaticObj.UserName);//修改人姓名
comField.Add("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString());//修改时间
bool flag = DBHelper.BatchUpdateDataByIn("批量删除宇通旧件返厂单", "tb_maintain_oldpart_recycle", comField, "return_id", listField.ToArray());
if (flag)
{
BindPageData();
if (dgvRData.Rows.Count > 0)
{
dgvRData.CurrentCell = dgvRData.Rows[0].Cells[0];
}
MessageBoxEx.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBoxEx.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBoxEx.Show("删除失败！" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public List<dr_pre_visit> SearchPreVisitList(int drid, int visit_id, int patient_id, DateTime? pre_date1, DateTime? pre_date2,
string pre_time, int pre_type, DateTime? createtime1, DateTime? createtime2, int status , DateTime? visit_date1, DateTime? visit_date2,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select *,COALESCE(info.name,'') as patient_name,info.gender as gender from dr_pre_visit pre left join dr_visit on pre.visit_id=dr_visit.pkid left join patient_info info on pre.patient_id=info.pkid WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (drid > 0)
{
conditionSb.Append(" AND dr_visit.drid = @drid ");
paraList.Add(new MySqlParameter("drid", drid));
}
if (visit_id > 0)
{
conditionSb.Append(" AND pre.visit_id = @visit_id ");
paraList.Add(new MySqlParameter("visit_id", visit_id));
}
if (patient_id > 0)
{
conditionSb.Append(" AND pre.patient_id = @patient_id ");
paraList.Add(new MySqlParameter("patient_id", patient_id));
}
if (pre_date1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(pre.pre_date,@pre_date1) >= 0 ");
paraList.Add(new MySqlParameter("pre_date1", pre_date1.Value));
}
if (pre_date2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(pre.pre_date,@pre_date2) <= 0 ");
paraList.Add(new MySqlParameter("pre_date2", pre_date2.Value));
}
if (!string.IsNullOrEmpty(pre_time))
{
conditionSb.Append(" AND pre.pre_time = @pre_time ");
paraList.Add(new MySqlParameter("pre_time", pre_time));
}
if (pre_type > 0)
{
conditionSb.Append(" AND pre.pre_type = @pre_type ");
paraList.Add(new MySqlParameter("pre_type", pre_type));
}
if (visit_date1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(pre.createtime,@createtime1) >= 0 ");
paraList.Add(new MySqlParameter("createtime1", createtime1.Value));
}
if (createtime2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(pre.createtime,@createtime2) <= 0 ");
paraList.Add(new MySqlParameter("createtime2", createtime2.Value));
}
if (status > 0)
{
conditionSb.Append(" AND dr_visit.status = @status ");
paraList.Add(new MySqlParameter("status", status));
}
if (visit_date1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(dr_visit.visit_date,@visit_date1) >= 0 ");
paraList.Add(new MySqlParameter("visit_date1", visit_date1.Value));
}
if (visit_date2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(dr_visit.visit_date,@visit_date2) <= 0 ");
paraList.Add(new MySqlParameter("visit_date2", visit_date2.Value));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by pre.pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = db.Database.SqlQuery<dr_pre_visit>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void UCPersonnelManager_DeleteEvent(object sender, EventArgs e)
{
List<string> listField = new List<string>();
List<DataGridViewRow> deleteUser = new List<DataGridViewRow>();
foreach (DataGridViewRow dr in dgvUser.Rows)
{
object isCheck = dr.Cells["colCheck"].EditedFormattedValue;
if (isCheck != null && (bool)isCheck)
{
listField.Add(dr.Cells["user_id"].Value.ToString());
deleteUser.Add(dr);
}
}
if (listField.Count == 0)
{
MessageBoxEx.Show("请选择删除记录！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBoxEx.ShowQuestion("是否确认删除?"))
{
Dictionary<string, string> comField = new Dictionary<string, string>();
comField.Add("enable_flag", "0");
bool flag = DBHelper.BatchUpdateDataByIn("批量删除人员", "sys_user", comField, "user_id", listField.ToArray());
if (flag)
{
UploadUserData(listField);
BindPageData();
if (dgvUser.Rows.Count > 0)
{
dgvUser.CurrentCell = dgvUser.Rows[0].Cells[0];
}
MessageBoxEx.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
LocalCache._Update(CacheList.User);
}
else
{
MessageBoxEx.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
protected override TestGroup[] SelectGroups(TestNode testNode)
{
List<TestGroup> groups = new List<TestGroup>();
foreach (XmlNode node in testNode.Xml.SelectNodes("properties/property[@name='Category']"))
{
var groupName = node.Attributes["value"].Value;
var group = Groups.Find((g) => g.Name == groupName);//GetGroup(groupName);
if (group == null)
{
group = new TestGroup(groupName);
Groups.Add(group);
groups.Add(group);
}
}
if (groups.Count == 0)
groups.Add(Groups[0]);
return groups.ToArray();
}
/// <summary> SQLBulk方式操作带事务无操作备份
/// </summary>
/// <param name="connStr">数据库连接串</param>
/// <param name="tableName">表名</param>
/// <param name="listRow">DataRowList集合</param>
/// <returns>SQLBulk批处理方式操作带事务，执行结果。全部成功，返回Bool True; 否则，返回False。</returns>
public static bool SqlBulkByTransNoLogNoBackUp(string connStr, string tableName, List<DataRow> listRow)
{
if (listRow.Count == 0)
{
return true;
}
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.CheckConstraints, tran))
{
bulkCopy.DestinationTableName = tableName;
bulkCopy.BulkCopyTimeout = 300;
DataTable dt = listRow[0].Table;
foreach (DataColumn dc in dt.Columns)
{
bulkCopy.ColumnMappings.Add(dc.ColumnName, dc.ColumnName);
}
try
{
bulkCopy.WriteToServer(listRow.ToArray());
tran.Commit();
return true;
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
bulkCopy.Close();
tran.Dispose();
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Wgw_listEntity model)
{
StringBuilder strSql = new StringBuilder();
List<SqlParameter> parameters = new List<SqlParameter>();
strSql.Append("update Wgw_list set ");
if (!string.IsNullOrEmpty(model.typeone))
{
strSql.Append(" typeone = @typeone , ");
parameters.Add(new SqlParameter("@typeone", model.typeone));
}
if (!string.IsNullOrEmpty(model.typetwo))
{
strSql.Append(" typetwo = @typetwo , ");
parameters.Add(new SqlParameter("@typetwo", model.typetwo));
}
if (true)
{
strSql.Append(" pid = @pid , ");
parameters.Add(new SqlParameter("@pid", model.pid));
}
if (true)
{
strSql.Append(" clientid = @clientid , ");
parameters.Add(new SqlParameter("@clientid", model.clientid));
}
if (!string.IsNullOrEmpty(model.listname))
{
strSql.Append(" listname = @listname , ");
parameters.Add(new SqlParameter("@listname", model.listname));
}
if (!string.IsNullOrEmpty(model.listdesc))
{
strSql.Append(" listdesc = @listdesc , ");
parameters.Add(new SqlParameter("@listdesc", model.listdesc));
}
if (true)
{
strSql.Append(" listorder = @listorder , ");
parameters.Add(new SqlParameter("@listorder", model.listorder));
}
if (!string.IsNullOrEmpty(model.listcover))
{
strSql.Append(" listcover = @listcover , ");
parameters.Add(new SqlParameter("@listcover", model.listcover));
}
strSql.Append(" isshow = @isshow , ");
parameters.Add(new SqlParameter("@isshow", model.isshow));
if (!string.IsNullOrEmpty(model.icon))
{
strSql.Append(" icon = @icon , ");
parameters.Add(new SqlParameter("@icon", model.icon));
} strSql = strSql.Remove(strSql.Length - 2, 2);
strSql.Append(" where id=@id ");
parameters.Add(new SqlParameter("@id", model.id));
int rows = DBExecuteUtil.ExecuteSqlWithParams(strSql.ToString(), parameters.ToArray());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
protected CodeExpression CreateNewActionReference(ActionTreeNode node, List<CodeExpression> actionArguments, List<string> actionArgumentTypes)
{
var actionArgumentRuntimeTypes = new List<CodeExpression>();
foreach (var type in actionArgumentTypes)
actionArgumentRuntimeTypes.Add(new CodeTypeOfExpression(source[type]));
CodeExpression createMethodSignature = new CodeObjectCreateExpression(
source[typeof (MethodSignature)],
new CodeExpression[]
{
new CodeTypeOfExpression(node.Controller.FullName),
new CodePrimitiveExpression(node.Name),
new CodeArrayCreateExpression(source[typeof (Type)], actionArgumentRuntimeTypes.ToArray())
});
var constructionArguments = new[]
{
new CodeFieldReferenceExpression(new CodeThisReferenceExpression(), naming.ToMemberVariableName(serviceIdentifier)),
new CodeTypeOfExpression(node.Controller.FullName),
new CodePrimitiveExpression(node.Controller.Area),
new CodePrimitiveExpression(naming.ToControllerName(node.Controller.Name)),
new CodePrimitiveExpression(node.Name),
createMethodSignature,
new CodeArrayCreateExpression(source[typeof (ActionArgument)], actionArguments.ToArray())
};
return new CodeMethodInvokeExpression(
new CodeMethodReferenceExpression(
new CodePropertyReferenceExpression(
new CodeFieldReferenceExpression(new CodeThisReferenceExpression(), naming.ToMemberVariableName(serviceIdentifier)),
"ControllerReferenceFactory"),
"CreateActionReference"),
constructionArguments);
}
public List<md_druginfo> SearchDruginfoList(string drugname, string standard, int producerid, string cust_name, string sub_name,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select * from md_druginfo WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (!string.IsNullOrEmpty(drugname))
{
conditionSb.Append(" AND drugname LIKE CONCAT('%', @drugname, '%') ");
paraList.Add(new MySqlParameter("drugname", drugname));
}
if (!string.IsNullOrEmpty(standard))
{
conditionSb.Append(" AND standard LIKE CONCAT('%', @standard, '%') ");
paraList.Add(new MySqlParameter("standard", standard));
}
if (producerid > 0)
{
conditionSb.Append("AND producerid = @producerid");
paraList.Add(new MySqlParameter("producerid", producerid));
}
if (!string.IsNullOrEmpty(cust_name))
{
conditionSb.Append(" AND cust_name LIKE CONCAT('%', @cust_name, '%') ");
paraList.Add(new MySqlParameter("cust_name", cust_name));
}
if (!string.IsNullOrEmpty(sub_name))
{
conditionSb.Append(" AND sub_name LIKE CONCAT('%', @sub_name, '%') ");
paraList.Add(new MySqlParameter("sub_name", sub_name));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = sqlHelper.ExecuteObjects<md_druginfo>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
public List<patient_recipelist> SearchReciptList(int drid,int medical_rcd_id ,int hospital_id ,int patient_id ,string cust_name ,
DateTime? issue_time1 ,DateTime? issue_time2 , DateTime? createtime1 ,DateTime? createtime2,string check_result ,int fileid,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select *,COALESCE(info.name,'') as patient_name,info.gender as gender from patient_recipelist rec left join patient_info info on rec.patient_id=info.pkid WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (drid > 0)
{
conditionSb.Append("AND drid = @drid");
paraList.Add(new MySqlParameter("drid", drid));
}
if (medical_rcd_id > 0)
{
conditionSb.Append("AND medical_rcd_id = @medical_rcd_id");
paraList.Add(new MySqlParameter("medical_rcd_id", medical_rcd_id));
}
if (hospital_id > 0)
{
conditionSb.Append("AND hospital_id = @hospital_id");
paraList.Add(new MySqlParameter("hospital_id", hospital_id));
}
if (patient_id > 0)
{
conditionSb.Append("AND patient_id = @patient_id");
paraList.Add(new MySqlParameter("patient_id", patient_id));
}
if (!string.IsNullOrEmpty(cust_name))
{
conditionSb.Append(" AND cust_name = @cust_name ");
paraList.Add(new MySqlParameter("cust_name", cust_name));
}
if (issue_time1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(issue_time,@issue_time1) >= 0 ");
paraList.Add(new MySqlParameter("issue_time1", issue_time1.Value));
}
if (issue_time2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(issue_time,@issue_time2) <= 0 ");
paraList.Add(new MySqlParameter("issue_time2", issue_time2.Value));
}
if (createtime1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(rec.createtime,@createtime1) >= 0 ");
paraList.Add(new MySqlParameter("createtime1", createtime1.Value));
}
if (createtime2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(rec.createtime,@createtime2) <= 0 ");
paraList.Add(new MySqlParameter("createtime2", createtime2.Value));
}
if (fileid > 0)
{
conditionSb.Append("AND fileid = @fileid");
paraList.Add(new MySqlParameter("fileid", fileid));
}
if (!string.IsNullOrEmpty(check_result))
{
conditionSb.Append(" AND check_result = @check_result ");
paraList.Add(new MySqlParameter("check_result", check_result));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by rec.pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = db.Database.SqlQuery<patient_recipelist>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
/// <summary> 批量更新- 多条语句-事务
/// </summary
public static int BatchUpdateDataMultiByTrans(string connStr, IList<UpdateSQLObj> batUpdateList, UserIDOP userID)
{
StringBuilder sb = new StringBuilder();
List<SqlParameter> paramList = new List<SqlParameter>();
string str = string.Empty;
int index = 0;
foreach (UpdateSQLObj sqlObj in batUpdateList)
{
sb.Append(" Update ");
sb.Append(sqlObj.TableName);
sb.Append(" Set ");
bool isFirstValue = true;
foreach (string key in sqlObj.DicParam.Keys)
{
if (isFirstValue)
{
isFirstValue = false;
sb.Append(key);
sb.Append("=");
sb.Append("@Param" + index.ToString());
}
else
{
sb.Append("," + key);
sb.Append("=");
sb.Append("@Param" + index.ToString());
}
paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.DicParam[key]));
index++;
}
if (sqlObj.pkName != null)
{
sb.Append(" Where ").Append(sqlObj.pkName).Append("=").Append("@Param" + index.ToString()).Append(";");
paramList.Add(new SqlParameter("@Param" + index.ToString(), sqlObj.pkVal));
index++;
}
else if (!string.IsNullOrEmpty(sqlObj.whereString))
{
sb.Append(" Where ").Append(sqlObj.whereString).Append(";");
}
}
object _object = SqlHelper.ExecuteNonQueryTran(connStr, CommandType.Text, sb.ToString(), userID, paramList.ToArray());
return (_object == DBNull.Value) ? 0 : Convert.ToInt32(_object);
}
private Model.BusLine GetBusLineInfo(string infoURL)
{
Model.BusLine blModel = new Model.BusLine();
string str = PostWebRequest(infoURL, "", encoding, false);
Regex qzp = new Regex("<span class=\"red mr10\">.+?</span>站牌信息");
Regex qzp0 = new Regex("<span class=\"red mr10\">");
Regex qzp1 = new Regex("</span>站牌信息");
string routName = qzp.Match(str).Value;
routName= qzp0.Replace(routName, "");
routName = qzp1.Replace(routName, "");
blModel.RouteName = routName;
Regex qrm = new Regex("<div class=\"line_info\">[\\s\\S]+?<div class=\"line_point\">");
Regex qrm0 = new Regex("<p>.+?</p>");
Regex qrm1 = new Regex("<p>");
Regex qrm2 = new Regex("</p>");
string remarks = "";
remarks= qrm.Match(str).Value;
remarks = qrm0.Match(remarks).Value;
remarks = qrm1.Replace(remarks, "");
remarks = qrm2.Replace(remarks, "");
Regex qrmk = new Regex("<div class=\"line_time\">[\\s\\S]+?<div class=\"line_point\">");
Regex qrmk0 = new Regex("<p>.+?</p>");
Regex qrmk1 = new Regex("<p>");
Regex qrmk2 = new Regex("</p>");
string remarks2 = "";
remarks2 = qrmk.Match(str).Value;
remarks2 = qrmk0.Match(remarks2).Value;
remarks2 = qrmk1.Replace(remarks2, "");
remarks2 = qrmk2.Replace(remarks2, "");
remarks = remarks + remarks2;
blModel.Remarks = remarks;
List<string> stations = new List<string>();
Regex qstt = new Regex("<a href=\"http://bus.aibang.com/ningbo/station-[\\s\\S]+? name=\".+?\"");
Regex qstt0 = new Regex("<a href=\"http://bus.aibang.com/ningbo/station-[\\s\\S]+? name=\"");
Regex qstt1 = new Regex("\"");
MatchCollection mCollection = qstt.Matches(str);
foreach (Match m in mCollection)
{
string astt = qstt0.Replace(m.ToString(), "");
astt = qstt1.Replace(astt, "");
stations.Add(astt);
}
blModel.Station = stations.ToArray();
return blModel;
}
public List<chk_demo> SearchChkTypeList(
int typeid, string chk_item,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select * from chk_demo WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (typeid > 0)
{
conditionSb.Append(" AND typeid = @typeid ");
paraList.Add(new MySqlParameter("typeid", typeid));
}
if (!string.IsNullOrEmpty(chk_item))
{
conditionSb.Append(" AND chk_item like CONCAT('%'@,chk_item,'%') ");
paraList.Add(new MySqlParameter("chk_item", chk_item));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = db.Database.SqlQuery<chk_demo>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
/// <summary>
/// Pushes the version taken as a parameter
/// Will return any changes that conflicts
/// IMPORTANT: The version is not commited at the server before null is returned!
/// </summary>
/// <param name="path">The path to the repository to push</param>
/// <param name="number">The version number used to identify the right version</param>
/// <param name="log">The changes given by a number of text-.</param>
/// <param name="user">The user to submit changes.</param>
/// <returns>
/// Any changes that conflicts or null if version is commited
/// </returns>
/// <exception cref="System.ArgumentNullException">Log can't be null</exception>
/// <exception cref="System.ArgumentException">Log can't be empty</exception>
public string[][] PushVersion(String path, int number, string[] log, User user)
{
if (log == null) throw new ArgumentNullException("Log can't be null");
if (log.Length < 1) throw new ArgumentException("Log can't be empty");
if (user == null) throw new ArgumentNullException("User can't be null");
if (String.IsNullOrEmpty(user.Name)) throw new ArgumentException("User's name is invalid: " + user.Name);
if (String.IsNullOrEmpty(user.Password)) throw new ArgumentException("User's password is invalid");
if (user.MAC == null) throw new ArgumentNullException("User's MAC address is invalid (" + user.MAC + " and can therefore not push");
Console.WriteLine("[" + DateTime.Now + "]: " + "User is pushing to the server: " + user.MAC);
//See if the user is known - if not: Throw an exception
//Connect(user);
var returnArray = new string[0][];
// Test that the version number is correct - otherwise we'll just store things at the wrong places.
var vcs = new ServerVersionControlSystem(path, _fileSystem);
var currentVersion = vcs.GetLatestVersionNumber();
if (currentVersion != number - 1)
{
throw new ArgumentException("Can not push version " + number + " to the server version " + currentVersion);
}
// If the last user that attempted to push is the same as the current user, no conflicts will occur.
if (PushedLastVersion(user))
{
// We can assume that everything has been resolved client side and execute all the changes made
IList<AbstractChange> changeList = ChangeParser.ParseChanges(log).Where(item => item != null).ToList();
// Store the version
SaveChanges(number, user, vcs, changeList);
}
else
{
String[] simpleChanges = SearchForSimpleChanges(log);
String[,] complexChanges = SearchForComplexChanges(log);
ISet<String> conflictingPathsOnServerSet = new SortedSet<string>();
ISet<String> conflictingPathsOnClientSet = new SortedSet<string>();
//Get paths to all text files in project directory and all sub directories.
String absolutePath = vcs.GetFileSystemRoot() + path;
IList<String> projectFilesList = new List<string>(Directory.GetFileSystemEntries(absolutePath, "*", SearchOption.AllDirectories).Where(s => s.Contains(FileSystem.META_DIR) == false));
// Discover potential conflicts
for (int i = 0; i < projectFilesList.Count; i++)
{
projectFilesList[i] = projectFilesList[i].Substring(vcs.GetFileSystemRoot().Length);
}
foreach (String filePath in simpleChanges)
{
if (projectFilesList.Contains(filePath))
{
conflictingPathsOnServerSet.Add(filePath);
conflictingPathsOnClientSet.Add(filePath);
}
}
for (int i = 0; i < complexChanges.Length; i++)
{
if (projectFilesList.Contains(complexChanges[i, 0]))
{
conflictingPathsOnServerSet.Add(complexChanges[i, 0]);
conflictingPathsOnClientSet.Add(complexChanges[i, 1]);
}
}
// If no conflicts arises we can save the change to the file system
if (conflictingPathsOnServerSet.Count == 0)
{
SaveChanges(number, user, vcs, ChangeParser.ParseChanges(log));
}
else // Otherwise we find the conflicting paths and return the contents of the file on the
// server for the client to merge
{
IList<String> conflictingPathsOnServer = new List<string>(conflictingPathsOnServerSet);
IList<String> conflictingPathsOnClient = new List<string>(conflictingPathsOnClientSet);
var list = new List<string[]>();
for (int i = 0; i < conflictingPathsOnServer.Count; i++)
{
var fileList = new List<string>() { conflictingPathsOnClient[i] };
fileList.AddRange(vcs.ReadAllLines(conflictingPathsOnServer[i]));
list.Add(fileList.ToArray());
}
returnArray = list.ToArray();
}
}
// Save the last MAC adress
_lastPushUser = user.Name;
//AddToPushHistory(user);
// Return the conflicts to the client
return returnArray;
}
public List<chk_info> SearchChkInfoList(
int medical_id, int patient_id, int chk_type_id, int chk_demo_id, int fileid, int drid,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select *,pat.name as patient_name,chk_type.name as chk_name,rcd.createtime as chk_time from chk_info chk left join patient_medical_rcd rcd on chk.medical_id=rcd.pkid left join patient_info pat on chk.patient_id=pat.pkid left join chk_type on chk.chk_type_id on chk_type.pkid WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (medical_id > 0)
{
conditionSb.Append(" AND medical_id = @medical_id ");
paraList.Add(new MySqlParameter("medical_id", medical_id));
}
if (patient_id > 0)
{
conditionSb.Append(" AND chk.patient_id = @patient_id ");
paraList.Add(new MySqlParameter("patient_id", patient_id));
}
if (chk_type_id > 0)
{
conditionSb.Append(" AND chk_type_id = @chk_type_id ");
paraList.Add(new MySqlParameter("chk_type_id", chk_type_id));
}
if (chk_demo_id > 0)
{
conditionSb.Append(" AND chk_demo_id = @chk_demo_id ");
paraList.Add(new MySqlParameter("chk_demo_id", chk_demo_id));
}
if (fileid > 0)
{
conditionSb.Append(" AND fileid = @fileid ");
paraList.Add(new MySqlParameter("fileid", fileid));
}
if (drid > 0)
{
conditionSb.Append(" AND patient_medical_rcd.drid = @drid ");
paraList.Add(new MySqlParameter("drid", drid));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by chk.pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = db.Database.SqlQuery<chk_info>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
/// <summary>批量修改销售开单导入状态
/// </summary>
/// <param name="status">保存时：0 释放为正常，提交时：2 锁定</param>
void ImportSaleBillStatus(string status)
{
List<string> listField = new List<string>();
foreach (DataGridViewRow dr in gvPurchaseList.Rows)
{
string relation_order = dr.Cells["relation_order"].Value == null ? "" : dr.Cells["relation_order"].Value.ToString();
if (!string.IsNullOrEmpty(relation_order))
{
listField.Add(relation_order);
}
}
Dictionary<string, string> Field = new Dictionary<string, string>();
Field.Add("is_occupy", status);//单据导入状态，0正常，1占用，2锁定
DBHelper.BatchUpdateDataByIn("批量修改销售开单导入状态", "tb_parts_sale_billing", Field, "order_num", listField.ToArray());
}
void UCOldPartsPalautusView_DeleteEvent(object sender, EventArgs e)
{
if (MessageBoxEx.Show("确认要删除吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
List<SQLObj> listSql = new List<SQLObj>();
List<string> listField = new List<string>();
listField.Add(strPalautusId);
Dictionary<string, string> comField = new Dictionary<string, string>();
comField.Add("enable_flag", Convert.ToInt32(DataSources.EnumEnableFlag.DELETED).ToString());
comField.Add("update_by", HXCPcClient.GlobalStaticObj.UserID);//修改人Id
comField.Add("update_name", HXCPcClient.GlobalStaticObj.UserName);//修改人姓名
comField.Add("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString());//修改时间
bool flag = DBHelper.BatchUpdateDataByIn("删除宇通旧件返厂单", "tb_maintain_oldpart_recycle", comField, "return_id", listField.ToArray());
if (flag)
{
MessageBoxEx.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), "UCOldPartsPalautusView");
}
else
{
MessageBoxEx.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void ExportingImportingVMConfigAsTemplateforRepeatableUsage()
{
StartTest(MethodBase.GetCurrentMethod().Name, testStartTime);
// Create a new Azure quick VM
string newAzureQuickVMName = Utilities.GetUniqueShortName("PSTestVM");
if (string.IsNullOrEmpty(imageName))
imageName = vmPowershellCmdlets.GetAzureVMImageName(new[] { "Windows" }, false);
vmPowershellCmdlets.NewAzureQuickVM(OS.Windows, newAzureQuickVMName, serviceName, imageName, username, password, locationName); // New-AzureQuickVM
Console.WriteLine("VM is created successfully: -Name {0} -ServiceName {1}", newAzureQuickVMName, serviceName);
// starting the test.
string path = ".\\mytestvmconfig1.xml";
PersistentVMRoleContext vmRole = vmPowershellCmdlets.ExportAzureVM(newAzureQuickVMName, serviceName, path); // Export-AzureVM
Console.WriteLine("Exporting VM is successfully done: path - {0} Name - {1}", path, vmRole.Name);
vmPowershellCmdlets.RemoveAzureVM(newAzureQuickVMName, serviceName); // Remove-AzureVM
Assert.AreEqual(null, vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName));
Console.WriteLine("The VM is successfully removed: {0}", newAzureQuickVMName);
List<PersistentVM> VMs = new List<PersistentVM>();
foreach (var pervm in vmPowershellCmdlets.ImportAzureVM(path)) // Import-AzureVM
{
VMs.Add(pervm);
Console.WriteLine("The VM, {0}, is imported.", pervm.RoleName);
}
for (int i = 0; i < 3; i++)
{
try
{
vmPowershellCmdlets.NewAzureVM(serviceName, VMs.ToArray()); // New-AzureVM
Console.WriteLine("All VMs are successfully created.");
foreach (var vm in VMs)
{
Console.WriteLine("created VM: {0}", vm.RoleName);
}
break;
}
catch (Exception e)
{
if (e.ToString().ToLowerInvariant().Contains("currently in use") && i != 2)
{
Console.WriteLine("The removed VM is still using the vhd");
Thread.Sleep(120000);
continue;
}
else
{
Assert.Fail("error during New-AzureVM: {0}", e.ToString());
}
}
}
// Verify
PersistentVMRoleContext vmRoleCtxt = vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName);
Assert.AreEqual(newAzureQuickVMName, vmRoleCtxt.Name, true);
// Cleanup
vmPowershellCmdlets.RemoveAzureVM(newAzureQuickVMName, serviceName);
Assert.AreEqual(null, vmPowershellCmdlets.GetAzureVM(newAzureQuickVMName, serviceName));
pass = true;
}
/// <summary>
/// 对出诊表各个字段查询
/// </summary>
/// <param name="hospital_id"></param>
/// <param name="drid"></param>
/// <param name="visit_date1"></param>
/// <param name="visit_date2"></param>
/// <param name="visit_time"></param>
/// <param name="service_type"></param>
/// <param name="status"></param>
/// <param name="createtime1"></param>
/// <param name="createtime2"></param>
/// <param name="orderby">顺序 降序</param>
/// <param name="orderbyCol">排序字段,传入dr_visit的字段,不需要前缀</param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="error"></param>
/// <returns>null则出错</returns>
public List<dr_addvisit> SearchVisitList(int hospital_id, int drid, DateTime? visit_date1, DateTime? visit_date2, string visit_time,
int service_type, int status, DateTime? createtime1, DateTime? createtime2,
orderbyEnum? orderby, string orderbyCol, int pageIndex, int pageSize, out string error)
{
error = string.Empty;
try
{
#region Command
string selectSql = string.Format("select * from dr_addvisit WHERE TRUE ");
StringBuilder conditionSb = new System.Text.StringBuilder();
List<MySqlParameter> paraList = new List<MySqlParameter>();
#endregion
#region 搜索条件
if (hospital_id > 0)
{
conditionSb.Append("AND hospital_id = @hospital_id");
paraList.Add(new MySqlParameter("hospital_id", hospital_id));
}
if (drid > 0)
{
conditionSb.Append("AND drid = @drid");
paraList.Add(new MySqlParameter("drid", drid));
}
if (visit_date1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(visit_date,@visit_date1) >= 0 ");
paraList.Add(new MySqlParameter("visit_date1", visit_date1.Value));
}
if (visit_date2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(visit_date,@visit_date2) <= 0 ");
paraList.Add(new MySqlParameter("visit_date2", visit_date2.Value));
}
if (!string.IsNullOrEmpty(visit_time))
{
conditionSb.Append(" AND visit_time = @visit_time ");
paraList.Add(new MySqlParameter("visit_time", visit_time));
}
if (service_type > 0)
{
conditionSb.Append("AND service_type = @service_type");
paraList.Add(new MySqlParameter("service_type", service_type));
}
if (status > 0)
{
conditionSb.Append("AND status = @status");
paraList.Add(new MySqlParameter("status", status));
}
if (createtime1.HasValue)
{
conditionSb.Append(" AND DATEDIFF(createtime,@createtime1) >= 0 ");
paraList.Add(new MySqlParameter("createtime1", createtime1.Value));
}
if (createtime2.HasValue)
{
conditionSb.Append(" AND DATEDIFF(createtime,@createtime2) <= 0 ");
paraList.Add(new MySqlParameter("createtime2", createtime2.Value));
}
#endregion
#region 排序 分页
string orderbyStr = string.Empty;
if (!string.IsNullOrEmpty(orderbyCol) && orderby.HasValue)
orderbyStr = orderbyFormat.getSortStr(orderby.Value, orderbyCol);
else
orderbyStr = " order by pkid ";
selectSql += conditionSb.ToString() + orderbyStr;
if (pageIndex > 0)
{
selectSql += " LIMIT @pageIndex , @pageSize ";
paraList.Add(new MySqlParameter("pageIndex", (pageIndex - 1) * pageSize));
paraList.Add(new MySqlParameter("pageSize", pageSize));
}
#endregion
#region 执行
var resultList = db.Database.SqlQuery<dr_addvisit>(selectSql, paraList.ToArray()).ToList();
return resultList;
#endregion
}
catch (Exception ex)
{
error += BaseTool.FormatExceptionMessage(ex);
return null;
}
}
public Video[] GetAllVideo()
{
List<Video> myVideos = new List<Video>();
SqlConnection myConn = new SqlConnection(connstring);
myConn.Open();
SqlCommand mySqlCommand = new SqlCommand("select * from video", myConn);
SqlDataReader reader = mySqlCommand.ExecuteReader();
while (reader.Read())
{
Video myVideo = new Video();
object id = reader["Id"];
if(id != null)
{
int videoId = -1;
if (!int.TryParse(id.ToString(), out videoId))
{
throw new Exception("Failed to parse Id of video.");
}
myVideo.Id = videoId;
}
myVideo.Name = reader["Name"].ToString();
myVideo.Url = reader["Url"].ToString();
myVideos.Add(myVideo);
}
myConn.Close();
return myVideos.ToArray();
}
private static InfoItem[] GetTuple(MessageContext context)
{
if (context.Command.Verb == Verb.Create)
{
var items = new List<InfoItem>();
var commandFactory = context.Host.NodeHost.MessageProducer;
foreach (var node in context.Host.NodeHost.Nodes)
{
if (commandFactory.IsProduce(context, node))
{
bool isCare = false;
foreach (var item in context.InfoTuplePair.ValueTuple)
{
if (node.IsCareforElement(item.Element))
{
isCare = true;
items.Add(item);
}
}
if (isCare)
{
foreach (var element in node.GetInfoIdElements())
{
items.Add(InfoItem.Create(element, string.Empty));
}
}
}
}
return items.ToArray();
}
return context.TowInfoTuple.SingleInfoTuple;
}
/// <summary>批量修改采购计划单/销售订单的导入状态
/// </summary>
/// <param name="status">保存时：0 释放为正常，提交时：2 锁定</param>
void ImportPurchasePlanStatus(string status)
{
List<string> listFieldPurchasePlan = new List<string>();
List<string> listFieldSale = new List<string>();
foreach (DataGridViewRow dr in gvPurchaseList.Rows)
{
if (dr.Cells["parts_code"].Value == null)
{
continue;
}
string relation_order = dr.Cells["relation_order"].Value == null ? "" : dr.Cells["relation_order"].Value.ToString();
string ImportType = dr.Cells["ImportType"].Value == null ? "" : dr.Cells["ImportType"].Value.ToString();
if (!string.IsNullOrEmpty(relation_order))
{
if (ImportType == "采购计划单")
{
listFieldPurchasePlan.Add(relation_order);
}
else if (ImportType == "销售订单")
{
listFieldSale.Add(relation_order);
}
}
}
Dictionary<string, string> Field = new Dictionary<string, string>();
if (listFieldPurchasePlan.Count > 0)
{
Field.Add("import_status", status);//单据导入状态，0正常，1占用，2锁定
DBHelper.BatchUpdateDataByIn("批量修改采购计划单导入状态", "tb_parts_purchase_plan", Field, "order_num", listFieldPurchasePlan.ToArray());
}
if (listFieldSale.Count > 0)
{
Field.Add("is_occupy", status);//单据导入状态，0正常，1占用，2锁定
DBHelper.BatchUpdateDataByIn("批量修改销售订单单导入状态", "tb_parts_sale_order", Field, "order_num", listFieldSale.ToArray());
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PubtypeEntity model)
{
StringBuilder strSql = new StringBuilder();
List<SqlParameter> parameters = new List<SqlParameter>();
strSql.Append("update Pubtype set ");
if (!string.IsNullOrEmpty(model.typename))
{
strSql.Append(" typename = @typename , ");
parameters.Add(new SqlParameter("@typename", model.typename));
}
strSql.Append(" enable = @enable , ");
parameters.Add(new SqlParameter("@enable", model.enable));
strSql = strSql.Remove(strSql.Length - 2, 2);
strSql.Append(" where id=@id ");
parameters.Add(new SqlParameter("@id", model.id));
int rows = DBExecuteUtil.ExecuteSqlWithParams(strSql.ToString(), parameters.ToArray());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}