private void CreateUnboundButtonColumn()
{
// Initialize the button column.
DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn();
buttonColumn.Name = "Details";
buttonColumn.HeaderText = "Details";
buttonColumn.Text = "View Details";
// Use the Text property for the button text for all cells rather
// than using each cell's value as the text for its own button.
buttonColumn.UseColumnTextForButtonValue = true;
// Add the button column to the control.
grid.Columns.Insert(1, buttonColumn);
}
public async void ReadTasks(int userId)
{
try
{
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
string jsonString = string.Empty;
var client = new HttpClient();
// client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue(Token);
var values = new Dictionary <string, string>
{
{ "action", "tasks" },
{ "userid", userId.ToString() }
};
var content = new FormUrlEncodedContent(values);
HttpResponseMessage message = await client.PostAsync("https://buynowdepot.com/api.php", content);
var responseString = await message.Content.ReadAsStringAsync();
JObject j = (JObject)JsonConvert.DeserializeObject(responseString);
for (int i = 0; i < ((Newtonsoft.Json.Linq.JContainer)(j["data"])).Count; i++)
{
List <JToken> jt = j["data"][i].Select(jp => ((JProperty)jp)).ToList <JToken>();
UserTask usrTask = new UserTask();
foreach (JToken item in jt)
{
switch (((Newtonsoft.Json.Linq.JProperty)item).Name)
{
case "id":
usrTask.id = (int)((Newtonsoft.Json.Linq.JProperty)item).Value;
break;
case "title":
usrTask.title = ((Newtonsoft.Json.Linq.JProperty)item).Value.ToString();
break;
case "description":
usrTask.description = ((Newtonsoft.Json.Linq.JProperty)item).Value.ToString();
break;
}
}
LstUser.Add(usrTask);
}
grdTaskList.DataSource = LstUser; DataGridViewButtonColumn buttonColumn =
new DataGridViewButtonColumn();
buttonColumn.HeaderText = "";
buttonColumn.Name = "Starttask";
buttonColumn.Text = "Start Task";
buttonColumn.FlatStyle = FlatStyle.Flat;
buttonColumn.CellTemplate.Style.BackColor = Color.Orange;
buttonColumn.CellTemplate.Style.ForeColor = Color.White;
buttonColumn.CellTemplate.Style.SelectionBackColor = Color.Orange;
buttonColumn.CellTemplate.Style.SelectionForeColor = Color.White;
buttonColumn.HeaderCell.Style.BackColor = Color.Silver;
buttonColumn.CellTemplate.Style.Font = new Font(DataGridView.DefaultFont, FontStyle.Bold);
buttonColumn.UseColumnTextForButtonValue = true;
grdTaskList.Columns[0].Visible = false;
grdTaskList.Columns[1].HeaderText = "Tasks";
grdTaskList.Columns[1].HeaderCell.Style.BackColor = Color.Silver;
grdTaskList.Columns[1].HeaderCell.Style.ForeColor = Color.White;
grdTaskList.GridColor = Color.White;
grdTaskList.Columns[2].Visible = false;
grdTaskList.Columns.Add(buttonColumn);
grdTaskList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
grdTaskList.Columns[1].Width = 336;
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
private void Form扫描管理_Load(object sender, EventArgs e)
{
DataTable dt11 = new ZLXIBAL().Select7(lzId);
pId = dt11.Rows[0][0].ToString();
DataTable dt = new ZLXIBAL().Select3(lzId);
gdmethod = dt.Rows[0][0].ToString();
if (gdmethod == "项目")
{
DataTable dt3 = new ZLXIBAL().Select2(pId, lzId);
DataTable dt1 = new DataTable();
DataTable dt2 = new ZLXIBAL().Select1();
int i = 0;
int cnt = 0;
while (i < dt2.Rows.Count)
{
dt1.Columns.Add(dt2.Rows[i][0].ToString(), typeof(string));
cnt++;
i++;
}
for (int ss = 0; ss < dt3.Rows.Count;)
{
DataRow dr = dt1.NewRow();
for (int w = 0; w < cnt; w++)
{
dr[dt2.Rows[w][0].ToString()] = dt3.Rows[ss][0].ToString();
ss++;
}
ll++;
dt1.Rows.Add(dr);
}
dataGridView1.DataSource = dt1;
}
else if (gdmethod == "案卷")
{
dataGridView1.ReadOnly = true;
DataTable dt12 = new ZLBAL().Select112(pId, lzId);
DataTable dt111 = new DataTable();
DataTable dt5 = new AABAL().Select6(pId);
int m = 0;
int cnt2 = 0;
while (m < dt5.Rows.Count)
{
dt111.Columns.Add(dt5.Rows[m][0].ToString(), typeof(string));
cnt2++;
m++;
}
for (int ss = 0; ss < dt12.Rows.Count;)
{
DataRow dr = dt111.NewRow();
for (int w = 0; w < cnt2; w++)
{
dr[dt5.Rows[w][0].ToString()] = dt12.Rows[ss][1].ToString();
ss++;
}
ll++;
dt111.Rows.Add(dr);
}
dataGridView2.DataSource = dt111;
}
else
{
dataGridView1.ReadOnly = true;
dataGridView2.ReadOnly = true;
DataTable dt22 = new ZLBAL().Select1113(pId, lzId);
DataTable dt1 = new DataTable();
DataTable dt2 = new ZLXIBAL().Select6(pId);
int j = 0;
int cnt3 = 0;
while (j < dt2.Rows.Count)
{
dt1.Columns.Add(dt2.Rows[j][0].ToString(), typeof(string));
cnt3++;
j++;
}
for (int ss = 0; ss < dt22.Rows.Count;)
{
DataRow dr = dt1.NewRow();
for (int w = 0; w < cnt3; w++)
{
dr[dt2.Rows[w][0].ToString()] = dt22.Rows[ss][1].ToString();
ss++;
}
lw++;
dt1.Rows.Add(dr);
}
dataGridView3.DataSource = dt1;
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.Name = "btnck";
btn.HeaderText = "查看";
btn.DefaultCellStyle.NullValue = "查看";
dataGridView3.Columns.Add(btn);
DataGridViewButtonColumn btn2 = new DataGridViewButtonColumn();
btn2.Name = "btnsm";
btn2.HeaderText = "扫描";
btn2.DefaultCellStyle.NullValue = "扫描";
dataGridView3.Columns.Add(btn2);
}
}
private void DgvLoader()
{
DataTable dt = new DataTable();
string sSelectedPath = "";
if (rdoBrowse.Checked)
{
FolderBrowserDialog fbd = new FolderBrowserDialog();
fbd.Description = "Custom Description";
if (fbd.ShowDialog() == DialogResult.OK)
{
sSelectedPath = fbd.SelectedPath;
}
}
else
{
sSelectedPath = mainFolderLocation;
}
if (sSelectedPath == "")
{
return;
}
String[] s1;
s1 = Directory.GetFiles(@"" + sSelectedPath,
"*",
SearchOption.AllDirectories);
for (int i = 0; i < s1.Length; i++)
{
FileInfo f = new FileInfo(s1[i]);
if (!(f.FullName.EndsWith(".jpg") || f.Name.EndsWith(".png")))
{
continue;
}
FileSystemInfo f1 = new FileInfo(s1[i]);
dt = dgvFileInfo.DataSource as DataTable;
dr = dt.NewRow();
//Get File name of each file name
string mad = f1.Name;
for (int task = 20; task < mad.Length; task += 20)
{
mad = mad.Insert(task, Environment.NewLine);
task += 4;
}
dr["Name"] = mad;
//Get File Type/Extension of each file
Image loadedImage = resizeImage(Image.FromFile(f1.FullName), new Size(100, 100));
dr["Image"] = loadedImage;
//Get File Size of each file in KB format
dr["Size"] = (f.Length / 1024).ToString() + " KB";
//Get file Create Date and Time
mad = f1.FullName;
for (int task = 20; task < mad.Length; task += 20)
{
mad = mad.Insert(task, Environment.NewLine);
task += 4;
}
dr["Source"] = mad;
//dr["Update"] = btnUpdateGrid;
//dr["Delete"] = "Delete";
//dr["Download"] = "Download";
dt.Rows.Add(dr);
}
if (dt.Rows.Count > 0)
{
//Finally Add DataTable into DataGridView
dgvFileInfo.DataSource = dt;
DataGridViewButtonColumn btnUpdateGrid = new DataGridViewButtonColumn();
//Padding newPadding = new Padding(1);
//dgvFileInfo.RowTemplate.DefaultCellStyle.Padding = newPadding;
btnUpdateGrid.Text = "Update";
btnUpdateGrid.Name = "Update";
//btnUpdateGrid.DefaultCellStyle.BackColor = Color.AliceBlue;
btnUpdateGrid.FlatStyle = FlatStyle.Standard;
//btnUpdateGrid.DefaultCellStyle.BackColor = Color.Aqua;
btnUpdateGrid.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 14F, FontStyle.Bold, GraphicsUnit.Pixel);
btnUpdateGrid.UseColumnTextForButtonValue = true;
dgvFileInfo.Columns.Insert(4, btnUpdateGrid);
//----delete
DataGridViewButtonColumn btnDeleteGrid = new DataGridViewButtonColumn();
btnDeleteGrid.Text = "Delete";
btnDeleteGrid.Name = "Delete";
btnDeleteGrid.FlatStyle = FlatStyle.Standard;
//btnDeleteGrid.DefaultCellStyle.BackColor = Color.Aqua;
btnDeleteGrid.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 14F, FontStyle.Bold, GraphicsUnit.Pixel);
btnDeleteGrid.UseColumnTextForButtonValue = true;
dgvFileInfo.Columns.Insert(5, btnDeleteGrid);
//--- download
DataGridViewButtonColumn btnDownloadGrid = new DataGridViewButtonColumn();
btnDownloadGrid.Text = "Download";
btnDownloadGrid.Name = "Download";
btnDownloadGrid.FlatStyle = FlatStyle.Standard;
//btnDownloadGrid.DefaultCellStyle.BackColor = Color.Aqua;
btnDownloadGrid.DefaultCellStyle.Font = new Font("Microsoft Sans Serif", 14F, FontStyle.Bold, GraphicsUnit.Pixel);
btnDownloadGrid.UseColumnTextForButtonValue = true;
dgvFileInfo.Columns.Insert(6, btnDownloadGrid);
dgvFileInfo.Columns[4].DividerWidth = 2;
dgvFileInfo.Columns[5].DividerWidth = 2;
dgvFileInfo.Columns[6].DividerWidth = 2;
dgvFileInfo.Columns["Update"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvFileInfo.Columns["Delete"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvFileInfo.Columns["Download"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvFileInfo.Columns["Update"].DefaultCellStyle.Padding = new Padding(10, 25, 10, 25);
dgvFileInfo.Columns["Delete"].DefaultCellStyle.Padding = new Padding(10, 25, 10, 25);
dgvFileInfo.Columns["Download"].DefaultCellStyle.Padding = new Padding(8, 25, 8, 25);
}
}
private void Generator_Click(object sender, EventArgs e)
{
int bug = Int32.Parse(buget.Text);
var fel1 = new DataGridViewTextBoxColumn();
fel1.HeaderText = "Felul 1";
fel1.Name = "fel1";
var fel2 = new DataGridViewTextBoxColumn();
fel2.HeaderText = "Felul 2";
fel2.Name = "fel2";
var fel3 = new DataGridViewTextBoxColumn();
fel3.HeaderText = "Felul 3";
fel3.Name = "fel3";
var totalKcal = new DataGridViewTextBoxColumn();
totalKcal.HeaderText = "Total kcal";
totalKcal.Name = "totalKcal";
var totalPret = new DataGridViewTextBoxColumn();
totalPret.HeaderText = "Total pret";
totalPret.Name = "totalPret";
var alege = new DataGridViewButtonColumn();
alege.Name = "alege";
alege.HeaderText = "Alege";
alege.Text = "Alege";
alege.UseColumnTextForButtonValue = true;
dataGridView2.Columns.Add(fel1);
dataGridView2.Columns.Add(fel2);
dataGridView2.Columns.Add(fel3);
dataGridView2.Columns.Add(totalKcal);
dataGridView2.Columns.Add(totalPret);
var menuFel1 = RepositoryController.MeniuRepository.Query().Where(x => x.felul == 1).ToList();
var menuFel2 = RepositoryController.MeniuRepository.Query().Where(x => x.felul == 2).ToList();
var menuFel3 = RepositoryController.MeniuRepository.Query().Where(x => x.felul == 3).ToList();
foreach (var felul1 in menuFel1)
{
foreach (var felul2 in menuFel2)
{
foreach (var felul3 in menuFel3)
{
if (felul1.pret + felul2.pret + felul3.pret <= bug)
{
dataGridView2.Rows.Add(felul1.denumire_produs, felul2.denumire_produs, felul3.denumire_produs, felul1.kcal + felul2.kcal + felul3.kcal, felul1.pret + felul2.pret + felul3.pret);
}
felmenu1 = felul1;
felmenu2 = felul2;
felmnu3 = felul3;
}
}
}
dataGridView2.Columns.Add(alege);
dataGridView2.CellContentClick += DataGridView2_CellContentClick;
}
public DrawPanelForm()
{
InitializeComponent();
//sheet.Size = new Size(1000,1000);
double d = Math.Sqrt(4) - (double)2;
coordinatesTable.Visible = false;
V = new List <Vertex>();
VV = new BindingList <Vertex>();
draw = new Drawing(sheet.Width, sheet.Height);
E = new List <Edge>();
//graph = new Graph();
sheet.Image = draw.GetBitmap();
mainTab_dataGridView.AutoGenerateColumns = false;
mainTab_dataGridView.Columns.Add("num", "№ вершины");
mainTab_dataGridView.Columns.Add("xVertex", "X вершины");
mainTab_dataGridView.Columns.Add("yVertex", "Y вершины");
mainTab_dataGridView.Columns.Add("xVector", "X вектора");
mainTab_dataGridView.Columns.Add("xVector", "Y вектора");
mainTab_dataGridView.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
mainTab_dataGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
mainTab_dataGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
mainTab_dataGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
mainTab_dataGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//создание столбца кнопок
DataGridViewButtonColumn button_column = new DataGridViewButtonColumn();
button_column.Name = "deleteVertex";
button_column.HeaderText = "Удалить";
button_column.FlatStyle = FlatStyle.Popup;
button_column.DefaultCellStyle.BackColor = Color.Tomato;
button_column.Text = "✕";
mainTab_dataGridView.Columns.Add(button_column);
mainTab_dataGridView.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
mainTab_dataGridView.Columns[1].DataPropertyName = "x";
mainTab_dataGridView.Columns[2].DataPropertyName = "y";
mainTab_dataGridView.Columns[3].DataPropertyName = "xVector";
mainTab_dataGridView.Columns[4].DataPropertyName = "yVector";
// mainTab_dataGridView.Columns[3].DataPropertyName = "";
//// Bind the list to the BindingSource.
//this.customersBindingSource.DataSource = VV;
//// Attach the BindingSource to the DataGridView.
//this.coordinate_dGV.DataSource = this.customersBindingSource;
TriangleInfo_dgv.AutoGenerateColumns = false;
TriangleInfo_dgv.Columns.Add("num", "№ треугольника");
TriangleInfo_dgv.Columns.Add("density", "Плотность");
TriangleInfo_dgv.Columns.Add("edge1", "Ребро 1");
TriangleInfo_dgv.Columns.Add("edge2", "Ребро 2");
TriangleInfo_dgv.Columns.Add("edge3", "Ребро 3");
TriangleInfo_dgv.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
TriangleInfo_dgv.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
TriangleInfo_dgv.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
TriangleInfo_dgv.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
TriangleInfo_dgv.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
TriangleInfo_dgv.Columns[2].DataPropertyName = "sE1";
TriangleInfo_dgv.Columns[3].DataPropertyName = "sE2";
TriangleInfo_dgv.Columns[4].DataPropertyName = "sE3";
TriangleInfo_dgv.Columns[1].DataPropertyName = "DensityOfTriangle";
monitor = new Monitoring();
monitor.TriangulationHappened += Triangulation_On;
ScaleNUD.ValueChanged += ScaleNUD_ValueChanged;
}
public EditDiagnoses()
{
InitializeComponent();
#region TreeView
DataRow[] drs;
int i;
#region laryngopharynx
i = 1001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Laryngopharynx = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Laryngopharynx);
#endregion
#region esophagus
i = 2001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId eso_inf = new NodeWithId(drs[0]["name"].ToString(), i);
i = 3000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId eso_tum = new NodeWithId(drs[0]["name"].ToString(), i);
i = 4000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId eso_etc = new NodeWithId(drs[0]["name"].ToString(), i);
i = 2000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId esophagus = new NodeWithId(drs[0]["name"].ToString(), i);
esophagus.Nodes.Add(eso_inf);
esophagus.Nodes.Add(eso_tum);
esophagus.Nodes.Add(eso_etc);
tv.Nodes.Add(esophagus);
#endregion
#region Stomach
i = 5001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId stomach_inf = new NodeWithId(drs[0]["name"].ToString(), i);
i = 6000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId stomach_tum = new NodeWithId(drs[0]["name"].ToString(), i);
i = 7000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId stomach_etc = new NodeWithId(drs[0]["name"].ToString(), i);
i = 5000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId stomach = new NodeWithId(drs[0]["name"].ToString(), i);
stomach.Nodes.Add(stomach_inf);
stomach.Nodes.Add(stomach_tum);
stomach.Nodes.Add(stomach_etc);
tv.Nodes.Add(stomach);
#endregion
#region Duodenum
i = 10001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Duodenum = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Duodenum);
#endregion
#region SideView
i = 20000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId SideView = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(SideView);
#endregion
#region SmallBowel
i = 30001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId SmallBowel = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(SmallBowel);
#endregion
#region Colon
i = 40001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Colon_inf = new NodeWithId(drs[0]["name"].ToString(), i);
i = 50000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Colon_tum = new NodeWithId(drs[0]["name"].ToString(), i);
i = 60000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Colon_etc = new NodeWithId(drs[0]["name"].ToString(), i);
i = 40000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Colon = new NodeWithId(drs[0]["name"].ToString(), i);
Colon.Nodes.Add(Colon_inf);
Colon.Nodes.Add(Colon_tum);
Colon.Nodes.Add(Colon_etc);
tv.Nodes.Add(Colon);
#endregion
#region Anus
i = 30001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Anus = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Anus);
#endregion
#region Procedure
i = 100001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Procedure = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Procedure);
#endregion
#region Study
i = 200001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Study = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Study);
#endregion
#region Broncho
i = 300001;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Broncho = new NodeWithId(drs[0]["name"].ToString(), i);
tv.Nodes.Add(Broncho);
#endregion
#region Abdomen
#region Gallbladder
i = 1010000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Gallbladder = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
#region ExtrahepaticBileDuct
i = 1020000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId ExtrahepaticBileDuct = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
#region Liver
i = 1030000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Liver = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
#region Spleen
i = 1040000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Spleen = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
#region Pancreas
i = 1050000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Pancreas = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
#region Kidney
i = 1060000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Kidney = new NodeWithId(drs[0]["name"].ToString(), i);
#endregion
i = 1000000;
drs = CLocalDB.localDB.Tables["diag_category"].Select("id=" + i.ToString());
NodeWithId Abdmen = new NodeWithId(drs[0]["name"].ToString(), i);
Abdmen.Nodes.Add(Gallbladder);
Abdmen.Nodes.Add(ExtrahepaticBileDuct);
Abdmen.Nodes.Add(Liver);
Abdmen.Nodes.Add(Spleen);
Abdmen.Nodes.Add(Pancreas);
Abdmen.Nodes.Add(Kidney);
tv.Nodes.Add(Abdmen);
#endregion
#endregion
#region dgv
dgv.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dgv.DataSource = dt;
showList();
#region Add btDelete
DataGridViewButtonColumn btDelete = new DataGridViewButtonColumn(); //DataGridViewButtonColumnの作成
btDelete.Name = "btDelete"; //列の名前を設定
btDelete.UseColumnTextForButtonValue = true; //ボタンにテキスト表示
btDelete.Text = FindingsEditor.Properties.Resources.Delete; //ボタンの表示テキスト設定
dgv.Columns.Add(btDelete); //ボタン追加
#endregion
#region Header text
dgv.Columns["no"].HeaderText = "No";
dgv.Columns["name_eng"].HeaderText = FindingsEditor.Properties.Resources.English;
dgv.Columns["name_jp"].HeaderText = FindingsEditor.Properties.Resources.Japanese;
dgv.Columns["diag_order"].HeaderText = FindingsEditor.Properties.Resources.Order;
dgv.Columns["diag_visible"].HeaderText = FindingsEditor.Properties.Resources.Visible;
dgv.Columns["btDelete"].HeaderText = FindingsEditor.Properties.Resources.Delete;
dgv.Columns["tbUpdate"].HeaderText = FindingsEditor.Properties.Resources.Update;
#endregion
#region Design and Settings
dgv.Columns["noInsert"].Visible = false;
dgv.Columns["tbUpdate"].ReadOnly = true;
//カラム幅自動に設定
foreach (DataGridViewColumn dc in dgv.Columns)
{
dc.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
}
//並び替え
DataView dv = dt.DefaultView;
dv.Sort = "no ASC";
#endregion
#region event
this.dgv.CellValueChanged += new DataGridViewCellEventHandler(this.dgv_CellValueChanged);
this.dgv.CurrentCellDirtyStateChanged += new EventHandler(this.dgv_CurrentCellDirtyStateChanged);
#endregion
#endregion
}
private void searchBtn_Click(object sender, EventArgs e)
{
if (flagForSearch > 0 && flagForReset == 0)
{
Console.WriteLine("search called :{0}", flagForSearch);
clear();
}
ItemDAO itemsDAORef = new ItemDAOImpl();
Items itemsRef = new Items();
Category c = new Category();
c.categoryName = categorynameCmb.Text;
itemsRef.category = c;
itemsRef.itemName = null;
List <string> listNm = new List <string>();
listNm.Add("Item Name");
listNm.Add("Category Name");
listNm.Add("Item Desciption");
listNm.Add("Item Type");
listNm.Add("Quantity");
listNm.Add("Price");
List <ArrayList> itemList = new List <ArrayList>();
dataGridViewItemsList.ColumnHeadersVisible = true;
itemList = itemsDAORef.getItemsListSample(itemsRef);
dataGridViewItemsList.DataSource = CreateDataTable(listNm, itemList);
for (int i = 0; i < itemList.Count; i++)
{
double d = Convert.ToDouble(itemList[i][5]);
price.Add(d);
}
for (int i = 0; i < price.Count; i++)
{
Console.WriteLine("p[{0}]={1}", i, price[i]);
}
// dataGridViewItemsList.SelectedCells[0].ReadOnly = true;
//dataGridViewItemsList.Columns[0].ReadOnly = true;
//dataGridViewItemsList.Columns[1].ReadOnly = true;
//dataGridViewItemsList.Columns[2].ReadOnly = false;
//dataGridViewItemsList.Columns[3].ReadOnly = false;
//dataGridViewItemsList.Columns[4].ReadOnly = false;
//dataGridViewItemsList.Columns[5].ReadOnly = false;
// flag is used to ensure that the following buttons are added only once even if the search button pressed for number of times.
if (flag == 0)
{
DataGridViewButtonColumn col1 = new DataGridViewButtonColumn();
col1.UseColumnTextForButtonValue = true;
col1.Text = "+";
col1.Name = "+";
dataGridViewItemsList.Columns.Add(col1);
DataGridViewButtonColumn col2 = new DataGridViewButtonColumn();
col2.UseColumnTextForButtonValue = true;
col2.Text = "-";
col2.Name = "-";
dataGridViewItemsList.Columns.Add(col2);
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.UseColumnTextForButtonValue = true;
col.Text = "Add to Cart";
col.Name = "Add to Cart";
dataGridViewItemsList.Columns.Add(col);
dataGridViewItemsList.Columns[6].Width = 20;
dataGridViewItemsList.Columns[7].Width = 20;
dataGridViewItemsList.Columns[8].Width = 120;
flag++;
}
//else
{
//// to make the column to fixed to right corner position .changing the display index value will shuffle position of the column in between the other columns
//dataGridViewItemsList.Columns["Item Name"].DisplayIndex = 0;
//dataGridViewItemsList.Columns["Category Name"].DisplayIndex = 1;
//dataGridViewItemsList.Columns["Item Desciption"].DisplayIndex = 2;
//dataGridViewItemsList.Columns["Item Type"].DisplayIndex = 3;
//dataGridViewItemsList.Columns["Quantity"].DisplayIndex = 4;
//dataGridViewItemsList.Columns["Price"].DisplayIndex = 5;
//dataGridViewItemsList.Columns["+"].DisplayIndex = 6;
//dataGridViewItemsList.Columns["-"].DisplayIndex = 7;
//dataGridViewItemsList.Columns["Add to Cart"].DisplayIndex = 8;
}
flagForSearch++;
}
private void frmChiTietDonHangNew_Load(object sender, EventArgs e)
{
int maDH = frmQuanLyDonHang.gMaDH;
KhachHangBUS khBus = new KhachHangBUS();
KhachHangDTO khDto = new KhachHangDTO();
DonHangBUS dhBus = new DonHangBUS();
DonHangDTO dhDto = new DonHangDTO();
ChiTietDonHangBUS ctdhBus = new ChiTietDonHangBUS();
khDto = khBus.LayThongTinKhachHangTuMaDonHang(maDH);
dhDto = dhBus.LayBangMaDonHang(maDH);
cbmTrangThai_Them.DataSource = TrangThaiDonHangBUS.GetList();
cbmTrangThai_Them.DisplayMember = "TrangThai";
cbmTrangThai_Them.ValueMember = "MaTrangThai";
cbmTrangThai_Them.SelectedValue = dhDto.TrangThai;
txtMaKH_Them.Text = khDto.MaKhachHang.ToString();
txtTenKH_Them.Text = khDto.HoTen;
txtDiaChi_Them.Text = khDto.DiaChi;
txtDienThoai_Them.Text = khDto.DienThoai;
txtEmail_Them.Text = khDto.Email;
txtFacebook_Them.Text = khDto.Facebook;
txtTKNganHang_Them.Text = khDto.TKNganHang;
lbSoLuong.Text = dhDto.SoLuongSanPham.ToString();
lbTongTien.Text = dhDto.TongTien.ToString("n0");
txtPhiVanChuyen_Them.Text = dhDto.PhiVanChuyen.ToString("n0");
if (dhDto.HinhThucMua == 0)
{
rdGiaSi.Checked = true;
rdGiaLe.Checked = false;
}
else
{
rdGiaLe.Checked = true;
rdGiaSi.Checked = false;
}
dt = ctdhBus.LayDanhSachSanPham(maDH);
dtgvDanhSachSanPham_ChiTiet.DataSource = dt;
DataGridViewImageColumn imageCol = new DataGridViewImageColumn();
imageCol.Name = "img";
imageCol.HeaderText = "Hinh Anh";
imageCol.Width = _colWidth;
dtgvDanhSachSanPham_ChiTiet.Columns.Insert(2, imageCol);
DataGridViewButtonColumn btnColumn = new DataGridViewButtonColumn();
btnColumn.HeaderText = "";
btnColumn.Text = "Xóa";
btnColumn.UseColumnTextForButtonValue = true;
dtgvDanhSachSanPham_ChiTiet.Columns.Add(btnColumn);
formatData();
_firstLoad = false;
}
public void DibujarTablaLiquidar()
{
dgvDetalles.DataSource = new DataTable();
dgvDetalles.Columns.Clear();
if (dgvDetalles.Rows.Count > 0)
{
dgvDetalles.Rows.Clear();
}
DataGridViewButtonColumn dgvbtnUnidades = new DataGridViewButtonColumn();
dgvbtnUnidades.HeaderText = "Unidades";
if (dtDgvDetalles.Columns.Count < 1)
{
dtDgvDetalles.Columns.Add("codigo", typeof(string));
dtDgvDetalles.Columns.Add("descripcion", typeof(string));
dtDgvDetalles.Columns.Add("hab_fijo", typeof(string));
dtDgvDetalles.Columns.Add("hab_porc", typeof(string));
dtDgvDetalles.Columns.Add("ded_fijo", typeof(string));
dtDgvDetalles.Columns.Add("ded_porc", typeof(string));
dtDgvDetalles.Columns.Add("tipo", typeof(string));
dtDgvDetalles.Columns.Add("modo", typeof(string));
dtDgvDetalles.Columns.Add("formula_porc", typeof(string));
dtDgvDetalles.Columns.Add("unidades", typeof(string));
dtDgvDetalles.Columns.Add("total", typeof(string));
dtDgvDetalles.Columns.Add("resultado", typeof(string));
dtDgvDetalles.Columns.Add("codigoConceptoPorEmpresa", typeof(string));
dtDgvDetalles.Columns.Add("Haber($)", typeof(string));
dtDgvDetalles.Columns.Add("Haber(%)", typeof(string));
dtDgvDetalles.Columns.Add("Deducción($)", typeof(string));
dtDgvDetalles.Columns.Add("Deducción(%)", typeof(string));
foreach (DataRow row in dtXML.Rows)
{
DataRow newRow = dtDgvDetalles.NewRow();
newRow["codigo"] = row["codigo"];
newRow["descripcion"] = row["descripcion"];
newRow["hab_fijo"] = row["hab_fijo"];
newRow["hab_porc"] = row["hab_porc"];
newRow["ded_fijo"] = row["ded_fijo"];
newRow["ded_porc"] = row["ded_porc"];
newRow["tipo"] = row["tipo"];
newRow["modo"] = row["modo"];
newRow["formula_porc"] = row["formula_porc"];
newRow["unidades"] = row["unidades"];
newRow["total"] = row["total"];
newRow["resultado"] = row["resultado"];
newRow["codigoConceptoPorEmpresa"] = row["codigoConceptoPorEmpresa"];
dtDgvDetalles.Rows.Add(newRow);
}
}
dgvDetalles.DataSource = dtDgvDetalles;
dgvDetalles.Columns[0].HeaderText = "Código";
dgvDetalles.Columns[1].HeaderText = "Descripción";
dgvDetalles.Columns[10].HeaderText = "Total";
dgvDetalles.Columns[13].DisplayIndex = 2;
dgvDetalles.Columns[14].DisplayIndex = 3;
dgvDetalles.Columns[15].DisplayIndex = 4;
dgvDetalles.Columns[16].DisplayIndex = 5;
dgvDetalles.Columns.RemoveAt(9);
dgvDetalles.Columns.Insert(9, dgvbtnUnidades);
foreach (DataRow row in dtDgvDetalles.Rows)
{
int index = dtDgvDetalles.Rows.IndexOf(row);
dgvDetalles.Rows[index].Cells[9].Value = dtDgvDetalles.Rows[index][9];
}
dgvDetalles.Columns[2].Visible = false;
dgvDetalles.Columns[7].Visible = false;
dgvDetalles.Columns[3].Visible = false;
dgvDetalles.Columns[7].Visible = false;
dgvDetalles.Columns[4].Visible = false;
dgvDetalles.Columns[7].Visible = false;
dgvDetalles.Columns[5].Visible = false;
dgvDetalles.Columns[7].Visible = false;
dgvDetalles.Columns[6].Visible = false;
dgvDetalles.Columns[7].Visible = false;
dgvDetalles.Columns[8].Visible = false;
dgvDetalles.Columns[11].Visible = false;
dgvDetalles.Columns[12].Visible = false;
for (int i = 0; i < dgvDetalles.Columns.Count; i++)
{
dgvDetalles.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}
SetColorTable(dtDgvDetalles, dgvDetalles);
}
private void frmMorbilidad_Load_1(object sender, EventArgs e)
{
DataGridViewButtonColumn dgvbMorbilidad = new DataGridViewButtonColumn();
DataGridViewButtonColumn dgvbGestanteMorbilidad = new DataGridViewButtonColumn();
CapaDeNegocios.cMorbilidad oMorbilidad = new CapaDeNegocios.cMorbilidad();
CapaDeNegocios.cGestanteMorbilidad oGestanteMorbilidad = new CapaDeNegocios.cGestanteMorbilidad();
DataTable odtMorbilidad = new DataTable();
txtHistoriaClinica.Text = Codigo_Historia_Clinica;
dtpFechaHistoriaClinica.Value = Convert.ToDateTime(Fecha);
txt_DNI.Text = DNI;
txt_NombreCompleto.Text = Nomnbre_Completo;
txt_Edad.Text = Edad;
dgvbMorbilidad.Name = "Acción";
dgvbMorbilidad.Text = "Agregar";
dgvbMorbilidad.HeaderText = "Acción";
dgvbMorbilidad.UseColumnTextForButtonValue = true;
int columnIndex = 4;
oMorbilidad.Idtestablecimientosalud = IdEstablecimiento;
odtMorbilidad = oUtilitarios.enumerar_datatable(oMorbilidad.ListarMantenimientoMorbilidad(), 0);
dgvMorbilidad_.DataSource = odtMorbilidad;
dgvMorbilidad_.Columns.Insert(columnIndex, dgvbMorbilidad);
//dgvMorbilidad_.Columns[2].Visible = false;
dgvMorbilidad_.Columns[0].Width = 40;
dgvMorbilidad_.Columns[4].Width = 60;
dgvMorbilidad_.Columns[3].Width = 100;
cbFiltrar.SelectedItem = cbFiltrar.Items[0];
txtBuscar_.Focus();
odtGM.Columns.Add("N°", typeof(string));
odtGM.Columns.Add("Id Morbilidad", typeof(string));
odtGM.Columns.Add("Fecha", typeof(string));
odtGM.Columns.Add("Descripción", typeof(string));
/* Boton eliminar en dgvGestanteMorbilidad */
dgvbGestanteMorbilidad.Name = "Acción";
dgvbGestanteMorbilidad.Text = "Eliminar";
dgvbGestanteMorbilidad.HeaderText = "Acción";
dgvbGestanteMorbilidad.UseColumnTextForButtonValue = true;
int columnIndex2 = 4;
oGestanteMorbilidad.idthistoriaclinica = Id_Historia_Clinica;
odtGM = oUtilitarios.enumerar_datatable(oGestanteMorbilidad.ListarGestanteMorbilidad(), 0);
dgvGM.DataSource = odtGM;
//dgvGM.Columns.Insert(columnIndex2, dgvbGestanteMorbilidad);
i = dgvGM.Rows.Count;
dgvGM.Columns[1].Visible = false;
dgvGM.Columns[0].Width = 60;
dgvGM.Columns[2].Width = 120;
}
/// -------------------------------------------------------------------
/// <summary>
/// データグリッドビューの定義を行います </summary>
/// <param name="tempDGV">
/// データグリッドビューオブジェクト</param>
/// -------------------------------------------------------------------
private void gridSetting(DataGridView tempDGV)
{
try
{
//フォームサイズ定義
// 列スタイルを変更する
tempDGV.EnableHeadersVisualStyles = false;
tempDGV.ColumnHeadersDefaultCellStyle.BackColor = Color.SteelBlue;
tempDGV.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
// 列ヘッダー表示位置指定
tempDGV.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
// 列ヘッダーフォント指定
tempDGV.ColumnHeadersDefaultCellStyle.Font = new Font("Meiryo UI", 9, FontStyle.Regular);
// データフォント指定
tempDGV.DefaultCellStyle.Font = new Font("Meiryo UI", 9, FontStyle.Regular);
// 行の高さ
tempDGV.ColumnHeadersHeight = 20;
tempDGV.RowTemplate.Height = 20;
// 全体の高さ
//tempDGV.Height = 582;
// 奇数行の色
tempDGV.AlternatingRowsDefaultCellStyle.BackColor = SystemColors.ControlLight;
// 各列指定
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.UseColumnTextForButtonValue = true;
btn.Text = "選択";
tempDGV.Columns.Add(btn);
tempDGV.Columns[0].HeaderText = "";
tempDGV.Columns[0].Name = colSel;
tempDGV.Columns.Add(colDate, "日付");
tempDGV.Columns.Add(colKingaku, "金額");
tempDGV.Columns.Add(colMemo, "備考");
DataGridViewButtonColumn btn2 = new DataGridViewButtonColumn();
btn2.UseColumnTextForButtonValue = true;
btn2.Text = "削除";
tempDGV.Columns.Add(btn2);
tempDGV.Columns[4].HeaderText = "";
tempDGV.Columns[4].Name = colBtn;
tempDGV.Columns.Add(colID, "SID");
tempDGV.Columns[colID].Visible = false;
// 各列幅指定
tempDGV.Columns[colSel].Width = 50;
tempDGV.Columns[colDate].Width = 100;
tempDGV.Columns[colKingaku].Width = 90;
tempDGV.Columns[colBtn].Width = 50;
tempDGV.Columns[colMemo].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
tempDGV.Columns[colDate].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
tempDGV.Columns[colKingaku].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight;
tempDGV.Columns[colMemo].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
// 列固定
//tempDGV.Columns[colClient].Frozen = true;
// 行ヘッダを表示しない
tempDGV.RowHeadersVisible = false;
// 選択モード
tempDGV.SelectionMode = DataGridViewSelectionMode.CellSelect;
tempDGV.MultiSelect = false;
// 編集不可とする
tempDGV.ReadOnly = true;
//foreach (DataGridViewColumn d in tempDGV.Columns)
//{
// if (d.Name == colSel)
// {
// d.ReadOnly = false;
// }
// else
// {
// d.ReadOnly = true;
// }
//}
// 追加行表示しない
tempDGV.AllowUserToAddRows = false;
// データグリッドビューから行削除を禁止する
tempDGV.AllowUserToDeleteRows = false;
// 手動による列移動の禁止
tempDGV.AllowUserToOrderColumns = false;
// 列サイズ変更禁止
tempDGV.AllowUserToResizeColumns = false;
// 行サイズ変更禁止
tempDGV.AllowUserToResizeRows = false;
// 行ヘッダーの自動調節
//tempDGV.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
// 罫線
tempDGV.AdvancedColumnHeadersBorderStyle.All = DataGridViewAdvancedCellBorderStyle.None;
//tempDGV.BorderStyle = BorderStyle.Fixed3D;
tempDGV.CellBorderStyle = DataGridViewCellBorderStyle.None;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "エラーメッセージ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private async void timerRefresh_Tick(object sender, EventArgs e)
{
try
{
timerRefresh.Stop();
Text = _windowTitle + " - Loading Data";
lblLoading.Show();
Refresh();
_wsresult = await GetData();
grdIncidents.DataSource = _wsresult.ActiveIncidentDataTable;
grdIncidents.Columns["XCoord"].Visible = false;
grdIncidents.Columns["YCoord"].Visible = false;
grdIncidents.Columns["NumberOfUnits"].Visible = false;
grdIncidents.Columns["AlarmLevel"].Visible = false;
grdIncidents.Columns["CallTimeOpened"].Visible = false;
grdIncidents.Columns["DateRetrieved"].Visible = false;
grdIncidents.Columns["Agency"].Width = 45;
grdIncidents.Columns["KeyMap"].Width = 55;
grdIncidents.Columns["Latitude"].Width = 65;
grdIncidents.Columns["Longitude"].Width = 65;
grdIncidents.Columns["CombinedResponse"].Width = 60;
grdIncidents.Columns["AlarmLevelInt"].Width = 55;
grdIncidents.Columns["NumberOfUnitsInt"].Width = 55;
grdIncidents.Columns["CombinedResponse"].HeaderText = "Combined Response";
grdIncidents.Columns["NumberOfUnitsInt"].HeaderText = "# Units";
grdIncidents.Columns["AlarmLevelInt"].HeaderText = "Alarm Level";
grdIncidents.Columns["CallTimeOpenedDT"].HeaderText = "Call Time Opened";
if (_buttonColumn == null)
{
_buttonColumn = new DataGridViewButtonColumn
{
Name = _viewMapColumnName,
HeaderText = String.Empty,
Text = "View Map",
DisplayIndex = 8,
UseColumnTextForButtonValue = true,
Width = 65
};
grdIncidents.Columns.Add(_buttonColumn);
}
}
catch (System.ServiceModel.FaultException ex)
{
StringBuilder errorMessage = new StringBuilder();
string exceptionText = ex.ToString();
errorMessage.Append("An error occurred while communicating with the HFD incidents web service:\n\n");
errorMessage.Append(exceptionText.Left(_exceptionTextMaxLength));
if (exceptionText.Length > _exceptionTextMaxLength)
{
errorMessage.Append(" ...");
}
lblLoading.Hide();
MessageBox.Show(
errorMessage.ToString(),
"Unable to load incident data");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error: " + ex.Message);
}
finally
{
Text = _windowTitle;
lblLoading.Hide();
timerRefresh.Start();
}
}
public Form1()
{
InitializeComponent();
_windowTitle = Application.ProductName + " v" + System.Reflection.Assembly.GetEntryAssembly().GetName().Version;
_buttonColumn = null;
}
public void DataRYGridBuild(string[] cols, string[] colss, DataGridView datagridGiew, string[] vcols)
{
IList <TPYEMX> nodes = new List <TPYEMX>();
TPYEMX node = new TPYEMX();
node.ID = 0;
node.MXNAME = q(Msg_Type.titlechoice); //"请选择";//
nodes.Add(node);
MES_SY_TYPEMXLIST[] arr = ReadTYPEMX(8);
for (int j = 0; j < arr.Length; j++)
{
TPYEMX node1 = new TPYEMX();
node1.ID = arr[j].ID;
node1.MXNAME = arr[j].MXNAME;
nodes.Add(node1);
}
for (int i = 0; i < cols.Length; i++)
{
//DataGridViewButtonColumn
if (cols[i] == "XXXXXX")
{
DataGridViewComboBoxColumn acCode = new DataGridViewComboBoxColumn();
acCode.Name = cols[i];
acCode.DataPropertyName = colss[i];//对应数据源的字段
acCode.HeaderText = cols[i];
acCode.Width = 80;
datagridGiew.Columns.Add(acCode);
acCode.DataSource = nodes.ToList(); //这里需要设置一下combox的itemsource,以便combox根据数据库中对应的值自动显示信息
acCode.DisplayMember = "MXNAME";
acCode.ValueMember = "ID";
}
else if (cols[i] == q(Msg_Type.fielddelete) || cols[i] == q(Msg_Type.fieldxggw))// "删除" "修改岗位"
{
DataGridViewButtonColumn acCode = new DataGridViewButtonColumn();
acCode.Name = cols[i];
acCode.UseColumnTextForButtonValue = true;
acCode.Text = cols[i];
acCode.HeaderText = cols[i];
datagridGiew.Columns.Add(acCode);
}
else
{
DataGridViewTextBoxColumn acCode = new DataGridViewTextBoxColumn();
acCode.Name = cols[i];
acCode.DataPropertyName = colss[i];
acCode.HeaderText = cols[i];
if (cols[i] == q(Msg_Type.fieldwlxx)) //"物料信息"
{
acCode.Width = 200;
datagridGiew.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
}
else
{
acCode.Width = 100;
datagridGiew.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
//判断不显示的在 全部字段里面有没有 有的话 就隐藏该字段
if (vcols.Count(p => p == cols[i]) > 0)
{
acCode.Visible = false;
}
datagridGiew.Columns.Add(acCode);
}
}
datagridGiew.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
datagridGiew.RowTemplate.Height = 35;
datagridGiew.RowTemplate.DefaultCellStyle.Font = new Font(q(Msg_Type.fonttype), 11);
//datagridGiew.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
foreach (DataGridViewColumn item in datagridGiew.Columns)
{
item.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private void txtCantidadSelected_KeyPress(object sender, KeyPressEventArgs e)
{
if (txtCantidadSelected.Text.Trim() == "")
{
return;
}
if (e.KeyChar == (int)Keys.Enter)
{
dgvMaterialesAsignados.Enabled = true;
newItemMaterial = new MovMateriales();
newItemMaterial.numTicketString = NumTicketInicial;
newItemMaterial.codSIGA = dgvItemsSIGA.CurrentRow.Cells[0].Value.ToString();
newItemMaterial.Item_Nombre = dgvItemsSIGA.CurrentRow.Cells[1].Value.ToString();
newItemMaterial.Unidad_Medida = dgvItemsSIGA.CurrentRow.Cells[2].Value.ToString();
newItemMaterial.cantidad = Convert.ToInt32(txtCantidadSelected.Text);
newItemMaterial.estado = "REQUERIDO";
foreach (var item in lista_AddMateriales)
{
if (item.Item_Nombre.Equals(newItemMaterial.Item_Nombre) || item.codSIGA.Equals(newItemMaterial.codSIGA))
{
return;
}
}
lista_AddMateriales.Add(newItemMaterial);
dgvMaterialesAsignados.DataSource = lista_AddMateriales;
dgvMaterialesAsignados.Columns.Clear();
dgvMaterialesAsignados.AutoGenerateColumns = false;
/*DataGridViewTextBoxColumn numTicketString = new DataGridViewTextBoxColumn();
* numTicketString.HeaderText = "N° Atención";
* numTicketString.DataPropertyName = "numTicketString";
* numTicketString.Width = 150;
* dgvMaterialesAsignados.Columns.Add(numTicketString);*/
DataGridViewTextBoxColumn codSIGA = new DataGridViewTextBoxColumn();
codSIGA.HeaderText = "COD. SIGA";
codSIGA.DataPropertyName = "codSIGA";
codSIGA.Width = 90;
dgvMaterialesAsignados.Columns.Add(codSIGA);
DataGridViewTextBoxColumn Item_Nombre = new DataGridViewTextBoxColumn();
Item_Nombre.HeaderText = "ITEM";
Item_Nombre.DataPropertyName = "Item_Nombre";
Item_Nombre.Width = 550;
dgvMaterialesAsignados.Columns.Add(Item_Nombre);
DataGridViewTextBoxColumn Unidad_Medida = new DataGridViewTextBoxColumn();
Unidad_Medida.HeaderText = "U. MEDIDA";
Unidad_Medida.DataPropertyName = "Unidad_Medida";
Unidad_Medida.Width = 85;
dgvMaterialesAsignados.Columns.Add(Unidad_Medida);
DataGridViewTextBoxColumn cantidad = new DataGridViewTextBoxColumn();
cantidad.HeaderText = "CANTIDAD";
cantidad.DataPropertyName = "cantidad";
cantidad.Width = 80;
dgvMaterialesAsignados.Columns.Add(cantidad);
DataGridViewButtonColumn colBotones = new DataGridViewButtonColumn();
colBotones.Name = "colBtnDelete";
colBotones.HeaderText = "Eliminar Material";
colBotones.Width = 100;
this.dgvMaterialesAsignados.Columns.Add(colBotones);
lblMaterialesUtilziar.Visible = true;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string BillNo;
string Status;
if (string.IsNullOrEmpty(txtTransactionNo.Text))
{
BillNo = "%";
}
else
{
BillNo = txtTransactionNo.Text;
}
if (string.IsNullOrEmpty(ddlSrchStatus.Text) || ddlSrchStatus.Text == "All")
{
Status = "%";
}
else
{
Status = ddlSrchStatus.Text;
}
try
{
sqlhelper = new SQLHelper();
statusGrid.DataSource = null;
statusGrid.Columns.Clear();
ds = new DataSet();
ds = sqlhelper.ExecuteQueries("select TransactionNo as [Bill No],CustName as [Customer Name],Phone,DeliveryDate as [Delivery Date],Status,EmpID from workStatus where TransactionNo like '" + BillNo + "' and Status like'" + Status + "'");
if (ds.Tables[0].Rows.Count > 0)
{
statusGrid.DataSource = ds.Tables[0];
DataGridViewComboBoxColumn ddlStatus = new DataGridViewComboBoxColumn();
statusGrid.Columns.Remove("Status"); // Remove original
ddlStatus.HeaderText = "Status";
ddlStatus.MaxDropDownItems = 3;
ddlStatus.Items.Add("Pending");
ddlStatus.Items.Add("Working");
ddlStatus.Items.Add("Completed");
//ddlStatus.DataSource = ds.Tables[0];
//ddlStatus.DisplayMember = "Status";
ddlStatus.Width = 140;
// Hide drop-down arrow until selected
ddlStatus.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
// Allow sorting...
ddlStatus.SortMode = DataGridViewColumnSortMode.Automatic;
// Add ColumnDepartment onto DataGridView layout
statusGrid.Columns.Add(ddlStatus);
ds1 = new DataSet();
ds1 = sqlhelper.ExecuteQueries("select UserID,Name from Users");
if (ds1.Tables[0].Rows.Count > 0)
{
DataRow dr = ds1.Tables[0].NewRow();
dr["Name"] = "Select";
dr["UserID"] = 0;
ds1.Tables[0].Rows.InsertAt(dr, 0);
DataGridViewComboBoxColumn ddlEmp = new DataGridViewComboBoxColumn();
statusGrid.Columns.Remove("EmpID"); // Remove original
ddlEmp.HeaderText = "Employee";
ddlEmp.DataSource = ds1.Tables[0];
ddlEmp.DisplayMember = "Name";
ddlEmp.ValueMember = "UserID";
ddlEmp.Width = 140;
// Hide drop-down arrow until selected
ddlEmp.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
// Allow sorting...
ddlEmp.SortMode = DataGridViewColumnSortMode.Automatic;
// Add ColumnDepartment onto DataGridView layout
statusGrid.Columns.Add(ddlEmp);
DataGridViewButtonColumn btnUpdate = new DataGridViewButtonColumn();
btnUpdate.HeaderText = "Update";
btnUpdate.Text = "Update";
btnUpdate.UseColumnTextForButtonValue = true;
btnUpdate.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
btnUpdate.FlatStyle = FlatStyle.Standard;
btnUpdate.CellTemplate.Style.BackColor = Color.Honeydew;
statusGrid.Columns.Add(btnUpdate);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
statusGrid.Rows[i].Cells[4].Value = ds.Tables[0].Rows[i]["Status"].ToString();
if (string.IsNullOrEmpty(ds.Tables[0].Rows[i]["EmpID"].ToString()))
{
statusGrid.Rows[i].Cells[5].Value = int.Parse(ds1.Tables[0].Rows[0]["UserID"].ToString());
}
else
{
statusGrid.Rows[i].Cells[5].Value = int.Parse(ds.Tables[0].Rows[i]["EmpID"].ToString());
}
}
foreach (DataGridViewColumn dc in statusGrid.Columns)
{
if (dc.Index.Equals(4) || dc.Index.Equals(5))
{
dc.ReadOnly = false;
}
else
{
dc.ReadOnly = true;
}
}
}
else
{
FrmMessage.Show("Employees are not Found. Please Insert Employees First");
}
}
else
{
FrmMessage.Show("No Records Found");
}
}
catch (Exception ex)
{
}
}
/**
* @name configPackageDataGrid
* @brief Configure the data grid according to the result
* of the package search
*/
private void configPackageDataGrid(localhost.packages[] packages)
{
string[] row;
float totalPrice;
float returnTicketPrice;
String tipo;
packageDataGridView.Rows.Clear();
packageDataGridView.Columns.Clear();
packageDataGridView.ColumnCount = 9;
packageDataGridView.Columns[0].Name = "Tipo";
packageDataGridView.Columns[1].Name = "Origem";
packageDataGridView.Columns[2].Name = "Destino";
packageDataGridView.Columns[3].Name = "Hotel";
packageDataGridView.Columns[4].Name = "Hóspedes / Quarto";
packageDataGridView.Columns[5].Name = "Preço Total";
packageDataGridView.Columns[6].Name = "Preço Ida";
packageDataGridView.Columns[7].Name = "Preço Volta";
packageDataGridView.Columns[8].Name = "Preço Hotel";
// Hide the prices columns (only used for storing info)
packageDataGridView.Columns[6].Visible = false;
packageDataGridView.Columns[7].Visible = false;
packageDataGridView.Columns[8].Visible = false;
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
packageDataGridView.Columns.Add(btn);
btn.HeaderText = "Comprar";
btn.Text = "Comprar";
btn.Name = "btn";
btn.UseColumnTextForButtonValue = true;
if (packages != null)
{
for (int i = 0; i < packages.Length; i++)
{
if (packages[i].flightTicketReturn != null)
{
totalPrice = packages[i].flightTicketGoing.price + packages[i].flightTicketReturn.price +
packages[i].accommodation.price;
returnTicketPrice = packages[i].flightTicketReturn.price;
tipo = "Ida/Volta";
}
else
{
totalPrice = packages[i].flightTicketGoing.price + packages[i].accommodation.price;
tipo = "Ida";
returnTicketPrice = 0;
}
row = new string[] { tipo, packages[i].flightTicketGoing.source,
packages[i].flightTicketGoing.dest, packages[i].accommodation.accommodationName,
packages[i].accommodation.maxGuestsPerRoom.ToString(), totalPrice.ToString(),
packages[i].flightTicketGoing.price.ToString(), returnTicketPrice.ToString(),
packages[i].accommodation.price.ToString() };
packageDataGridView.Rows.Add(row);
}
}
return;
}
public static List <DataGridViewColumn> GetDefinitionGroupEditorColumns()
{
var activeColumn = new DataGridViewCheckBoxColumn
{
HeaderText = "Active",
Name = "active",
Visible = true,
Width = 45,
SortMode = DataGridViewColumnSortMode.NotSortable
};
var invertedColumn = new DataGridViewCheckBoxColumn
{
HeaderText = "Inverted",
Name = "inverted",
Visible = true,
Width = 60,
SortMode = DataGridViewColumnSortMode.NotSortable
};
var definitionTypeColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Definition Type",
Name = "definition",
Visible = true,
Width = 180,
ReadOnly = true,
SortMode = DataGridViewColumnSortMode.NotSortable
};
var definitionAttributesColumn = new DataGridViewTextBoxColumn
{
HeaderText = "Definition Attributes",
Name = "attributes",
Visible = true,
AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill,
ReadOnly = true,
SortMode = DataGridViewColumnSortMode.NotSortable
};
var editButtonColumn = new DataGridViewButtonColumn
{
HeaderText = "",
Name = "edit",
Visible = true,
Width = 35,
Text = "Edit",
ReadOnly = true,
UseColumnTextForButtonValue = true,
SortMode = DataGridViewColumnSortMode.NotSortable,
ToolTipText = "Edit definition"
};
var removeButtonColumn = new DataGridViewButtonColumn
{
HeaderText = "",
Name = "delete",
Visible = true,
Width = 35,
Text = "X",
ReadOnly = true,
UseColumnTextForButtonValue = true,
SortMode = DataGridViewColumnSortMode.NotSortable,
ToolTipText = "Delete definition"
};
return(new List <DataGridViewColumn>
{
activeColumn,
invertedColumn,
definitionTypeColumn,
definitionAttributesColumn,
editButtonColumn,
removeButtonColumn
});
}
public async void LoadDetalle()
{
dgvDetalles.DataSource = null;
dgvDetalles.Rows.Clear();
dgvDetalles.Columns.Clear();
dgvDetalles.Refresh();
var totalPrincipal = empeños.Sum(l => l.Monto);
var totalIntereses = empeños.SelectMany(l => l.Intereses).Sum(l => l.Monto);
var totalGeneral = totalPrincipal + totalIntereses;
var totalProrroga = empeños.Where(m => m.Prorrogas.Count() > 0).Sum(m => m.Monto + m.Intereses.Sum(i => i.Monto));
lblTotalProrroga.Text = empeños.Where(m => m.Prorrogas.Count() > 0).Count().ToString();
var totalActivos = empeños.Where(m => m.Estado == Estado.Vigente || m.Estado == Estado.Pendiente).Sum(m => m.Monto + m.Intereses.Sum(i => i.Monto));
var list = empeños.Select(x => new
{
Id = x.EmpenoId,
Empeño = x.Descripcion,
x.Cliente.Identificacion,
Cliente = x.Cliente.Nombre,
Estado = x.Estado,
Vencimiento = x.FechaVencimiento,
Empleado = x.Empleado.Nombre,
x.Prorroga,
x.Monto,
MontoPendiente = x.MontoPendiente,
x.Intereses,
x.Prorrogas,
x.RetiradoAdministrador,
x.FechaRetiroAdministrador,
}).ToList();
var list2 = list.Select(x => new
{
x.Id,
x.Empeño,
x.Identificacion,
x.Cliente,
x.Estado,
Vencimiento = x.Vencimiento.ToString("dd/MM/yyyy"),
Vencido = (x.Vencimiento - DateTime.Today).TotalDays + " días",
x.Empleado,
x.Prorroga,
x.RetiradoAdministrador,
x.FechaRetiroAdministrador,
x.Prorrogas,
x.Monto,
MontoPendiente = (x.MontoPendiente + (x.Intereses != null ? x.Intereses.Sum(i => i.Monto - i.Pagado) : 0)).ToString("N2"),
x.Intereses
}).ToList();
dgvDetalles.DataSource = list2.Select(x => new
{
x.Id,
x.Empeño,
x.Identificacion,
x.Cliente,
x.Estado,
x.Vencimiento,
x.Vencido,
x.Empleado,
x.Prorroga,
x.RetiradoAdministrador,
x.Monto,
x.MontoPendiente,
}).ToList();
var totalVencido = empeños.Where(l => l.Estado == Estado.Vencido && l.Prorrogas.Count() == 0 && !l.RetiradoAdministrador).Sum(l => l.Monto + l.Intereses.Sum(i => i.Monto));
lblTotalVencidos.Text = empeños.Where(l => l.Estado == Estado.Vencido && l.Prorrogas.Count() == 0 && !l.RetiradoAdministrador).Count().ToString();
var totalRetirados = list2.Where(l => l.RetiradoAdministrador || l.FechaRetiroAdministrador != null).Sum(l => l.Monto + l.Intereses.Sum(i => i.Monto));
lblTotalRetirados.Text = list2.Where(l => l.RetiradoAdministrador || l.FechaRetiroAdministrador != null).Count().ToString();
////ADD BOTONES COLUMNS
var buttonDataGridView = new DataGridViewButtonColumn();
buttonDataGridView.FlatStyle = FlatStyle.Flat;
buttonDataGridView.HeaderText = "";
buttonDataGridView.Text = "Eliminar";
buttonDataGridView.UseColumnTextForButtonValue = true;
dgvDetalles.Columns.AddRange(buttonDataGridView);
buttonDataGridView = new DataGridViewButtonColumn();
buttonDataGridView.FlatStyle = FlatStyle.Flat;
buttonDataGridView.HeaderText = "";
buttonDataGridView.Text = "Prórroga";
buttonDataGridView.UseColumnTextForButtonValue = true;
dgvDetalles.Columns.AddRange(buttonDataGridView);
dgvDetalles.Refresh();
txtTotalVencido.Text = totalVencido.ToString("N2");
txtTotalRetirados.Text = totalRetirados.ToString("N2");
txtTotalProrroga.Text = totalProrroga.ToString("N2");
txtFecha.Text = DateTime.Now.ToString();
txtFecha.Enabled = false;
var empleadoId = await funciones.GetEmpleadoIdByUser(Program.Usuario.Usuario);
empleadoId = empleadoId == null ? 1 : empleadoId;
var empleado = await _context.Empleados.FindAsync(empleadoId);
txtEmpleado.Text = empleado.Nombre;
txtEmpleado.Enabled = false;
}
private void dgBindData()
{
string ordernum;
dataGridView1.Columns.Clear();
if (radbtn_All.Checked)
{
ordernum = "";
string allsql = "select OID as 订单编号, OGID as 商品编号, OGName as 商品名称, OGCID as 类别, OGAmount as 数量, OGPrice as 单价, OGUnit as 单位, OGSum as 总价, OPaymentMethod as 付款方式 from tb_Order where IsReturn='否' order by OID desc";
dataGridView1.DataSource = dgBindData(allsql).Tables[0];
if (dataGridView1.ColumnCount < 10)
{
DataGridViewTextBoxColumn column7 = new DataGridViewTextBoxColumn();
column7.Name = "退货原因";
dataGridView1.Columns.Add(column7);
DataGridViewButtonColumn column8 = new DataGridViewButtonColumn();
column8.HeaderText = "退货";
column8.UseColumnTextForButtonValue = true;
column8.Text = "提交";
column8.Name = "提交";
column8.UseColumnTextForButtonValue = true;
dataGridView1.Columns.Add(column8);
}
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].ReadOnly = true;
dataGridView1.Columns[4].ReadOnly = true;
dataGridView1.Columns[5].ReadOnly = true;
dataGridView1.Columns[6].ReadOnly = true;
dataGridView1.Columns[7].ReadOnly = true;
dataGridView1.Columns[8].ReadOnly = true;
dataGridView1.ClearSelection();
dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
//MessageBox.Show(dataGridView1.Columns["退货原因"].Index.ToString());
}
else
{
if (cmbox_OrderNum.SelectedItem != null)
{
ordernum = cmbox_OrderNum.Text.ToString().Trim();
string onsql = "select OID as 订单编号, OGID as 商品编号, OGName as 商品名称, OGCID as 类别, OGAmount as 数量, OGPrice as 单价, OGUnit as 单位, OGSum as 总价, OPaymentMethod as 付款方式 from tb_Order where OID='" + ordernum + "' and IsReturn='否' order by OID desc";
dataGridView1.DataSource = dgBindData(onsql).Tables[0];
if (dataGridView1.ColumnCount < 10)
{
DataGridViewTextBoxColumn column7 = new DataGridViewTextBoxColumn();
column7.Name = "退货原因";
dataGridView1.Columns.Add(column7);
DataGridViewButtonColumn column8 = new DataGridViewButtonColumn();
column8.HeaderText = "退货";
column8.UseColumnTextForButtonValue = true;
column8.Text = "提交";
column8.Name = "提交";
column8.UseColumnTextForButtonValue = true;
dataGridView1.Columns.Add(column8);
}
dataGridView1.Columns[0].ReadOnly = true;
dataGridView1.Columns[1].ReadOnly = true;
dataGridView1.Columns[2].ReadOnly = true;
dataGridView1.Columns[3].ReadOnly = true;
dataGridView1.Columns[4].ReadOnly = true;
dataGridView1.Columns[5].ReadOnly = true;
dataGridView1.Columns[6].ReadOnly = true;
dataGridView1.Columns[7].ReadOnly = true;
dataGridView1.Columns[8].ReadOnly = true;
dataGridView1.ClearSelection();
dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
}
else
{
MessageBox.Show("请选择订单编号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmbox_OrderNum.SelectedIndex = 0;
cmbox_OrderNum.Focus();
}
}
}
private void frmCompraDetalle_Load(object sender, EventArgs e)
{
DataGridViewButtonColumn botonColumna = dgvLineaCompra.Columns[0] as DataGridViewButtonColumn;
}
private void CreateTable()
{
//DataTable tblTable = new DataTable();
//tblTable.Columns.Add("N°");
//tblTable.Columns.Add("Cantidad");
//tblTable.Columns.Add("Estado");
//tblTable.Rows.Add("01", "5", "Ocupada");
//tblTable.Rows.Add("02", "3", "Disponible");
//tblTable.Rows.Add("03", "2", "Ocupada");
//tblTable.Rows.Add("04", "6", "Disponible");
//tblTable.Rows.Add("05", "5", "Ocupada");
//tblTable.Rows.Add("06", "5", "Disponible");
//tblTable.Rows.Add("07", "4", "Ocupada");
//tblTable.Rows.Add("08", "5", "Disponible");
//tblTable.Rows.Add("09", "2", "Disponible");
//tblTable.Rows.Add("10", "3", "Disponible");
DataGridViewComboBoxColumn dcombo = new DataGridViewComboBoxColumn();
dcombo.HeaderText = "ComboBox";
dcombo.Name = "ComboBox";
dcombo.Items.Add("A");
dcombo.Items.Add("B");
dcombo.Items.Add("C");
dcombo.Items.Add("D");
DataGridViewButtonColumn dbtn = new DataGridViewButtonColumn();
dbtn.UseColumnTextForButtonValue = true;
dbtn.HeaderText = "Button";
dbtn.Name = "Button";
dbtn.Text = "Click me";
DataGridViewCheckBoxColumn dcheck = new DataGridViewCheckBoxColumn();
dcheck.HeaderText = "CheckBox";
//METROTITLE
//MetroTile mtitl = new MetroTile();
//mtitl.Name = "Metro";
//mtitl.Text = "Mtro";
//mtitl.TextAlign = ContentAlignment.MiddleCenter;
//tbl_Tables.Columns.Add(mtitl);
//tbl_Tables.Columns.Add(dcombo);
tbl_Tables.Columns.Add(dbtn);
//tbl_Tables.Columns.Add(dcheck);
Button btnTable = new Button();
btnTable.Text = "aaa";
btnTable.Name = "a";
btnTable.UseCompatibleTextRendering = true;
btnTable.BackColor = Color.Green;
//Object[] row = new Object[] { 0, "01", "5", "Ocupada" , true};
//Object[] row = new Object[] { 0, "01", "5", "Ocupada", btnTable };
//tbl_Tables.Rows.Add(row);
//row = new Object[] { 1, "01", "5", "Disponible", btnTable };
//tbl_Tables.Rows.Add(row);
tbl_Tables.Rows.Insert(0, "01", "5", "Ocupada");
tbl_Tables.Rows.Insert(1, "02", "3", "Disponible");
tbl_Tables.Rows.Insert(2, "03", "2", "Ocupada");
tbl_Tables.Rows.Insert(3, "04", "6", "Disponible");
tbl_Tables.Rows.Insert(4, "05", "5", "Ocupada");
tbl_Tables.Rows.Insert(5, "06", "5", "Disponible");
tbl_Tables.Rows.Insert(6, "07", "4", "Ocupada");
tbl_Tables.Rows.Insert(7, "08", "5", "Disponible");
tbl_Tables.Rows.Insert(8, "09", "2", "Disponible");
tbl_Tables.Rows.Insert(9, "10", "3", "Disponible");
//COLOR CELLS
ManagerResaltados(tbl_Tables, 1, Color.Green);
//DataGridViewImageColumn dimg = new DataGridViewImageColumn();
//dimg.HeaderText = Properties.Resources.;
//Image img = Image.FromFile(@"C:/Imgs/..");
}
public void dgvNoticeShow()
{
string strSql = "select a.id,a.PATIENT_ID,a.PID 住院号,a.PATIENT_NAME 患者姓名,b.sick_bed_no 床号,CONTENT 通知内容,OPERATOR_USER_NAME 发送人,SEND_TIME 发送时间,type," +
"''质控状态,b.document_state from T_AMENDMENTS_INFO a inner join t_in_patient b on a.patient_id=b.id where RECEIVE_USER_ID='" +
App.UserAccount.UserInfo.User_id.ToString() + "' and STATE_FLAG=1 " + whereSql; //
DataSet ds = App.GetDataSet(strSql);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
//质控状态S：科室自评；H：院级；E：终末；
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["type"].ToString() == "S")
{
ds.Tables[0].Rows[i]["质控状态"] = "科室自评";
}
else if (ds.Tables[0].Rows[i]["type"].ToString() == "H")
{
ds.Tables[0].Rows[i]["质控状态"] = "院级评分";
}
else if (ds.Tables[0].Rows[i]["type"].ToString() == "E")
{
ds.Tables[0].Rows[i]["质控状态"] = "终末评分";
}
}
}
dgvNotice.Columns.Clear();
dgvNotice.DataSource = ds.Tables[0].DefaultView;
dgvNotice.Columns["id"].Visible = false;
dgvNotice.Columns["type"].Visible = false;
dgvNotice.Columns["PATIENT_ID"].Visible = false;
dgvNotice.Columns["document_state"].Visible = false;
DataGridViewButtonColumn btn_1 = new DataGridViewButtonColumn();
btn_1.Name = "colBtn_1";
btn_1.HeaderText = "详情";
btn_1.DefaultCellStyle.NullValue = "查看";
dgvNotice.Columns.Add(btn_1);
frmDocView.DataGridViewDisableButtonColumn btn_2 = new frmDocView.DataGridViewDisableButtonColumn();
btn_2.Name = "colBtn_2";
btn_2.HeaderText = "退回申请";
btn_2.UseColumnTextForButtonValue = true;
btn_2.Text = "申请";
dgvNotice.Columns.Add(btn_2);
//未归档患者不显示退回按钮
for (int i = 0; i < dgvNotice.Rows.Count; i++)
{
if (string.IsNullOrEmpty(dgvNotice.Rows[i].Cells["document_state"].Value.ToString()))
{
frmDocView.DataGridViewDisableButtonCell buttonCell1 = (frmDocView.DataGridViewDisableButtonCell)dgvNotice.Rows[i].Cells["colBtn_2"];
buttonCell1.Enabled = false;
}
}
for (int i = 0; i < dgvNotice.Columns.Count; i++)
{
dgvNotice.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
}
void FillGridView()
{
DataGridViewButtonColumn buttonColView = new DataGridViewButtonColumn();
buttonColView.Name = "View";
buttonColView.Text = "View";
buttonColView.UseColumnTextForButtonValue = true;
if (sqlCon.State == ConnectionState.Closed)
{
try
{
sqlCon.Open();
SqlDataAdapter sqlDa = new SqlDataAdapter(" SELECT Person.Id,Person.FirstName," +
"Person.LastName,Person.Contact,Person.Email,Person.DateOfBirth,Lookup.Value," +
"Student.RegistrationNo FROM (( Person INNER JOIN Lookup ON Lookup.Id=Person.Gender ) " +
"INNER JOIN Student ON Person.Id=Student.Id) ORDER BY Student.RegistrationNo", sqlCon);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
foreach (DataRow item in dtbl.Rows)
{
dataGridView1.AutoGenerateColumns = false;
dataGridView1.ColumnCount = 8;
dataGridView1.Columns[0].Name = "Id";
dataGridView1.Columns[0].HeaderText = "Id";
dataGridView1.Columns[0].DataPropertyName = "Id";
dataGridView1.Columns[0].Visible = false;
dataGridView1.Columns[1].Name = "FirstName";
dataGridView1.Columns[1].HeaderText = "FirstName";
dataGridView1.Columns[1].DataPropertyName = "FirstName";
dataGridView1.Columns[2].Name = "LastName";
dataGridView1.Columns[2].HeaderText = "LastName";
dataGridView1.Columns[2].DataPropertyName = "LastName";
dataGridView1.Columns[3].Name = "Contact";
dataGridView1.Columns[3].HeaderText = "Contact";
dataGridView1.Columns[3].DataPropertyName = "Contact";
dataGridView1.Columns[4].Name = "Email";
dataGridView1.Columns[4].HeaderText = "Email";
dataGridView1.Columns[4].DataPropertyName = "Email";
dataGridView1.Columns[5].Name = "DateOfBirth";
dataGridView1.Columns[5].HeaderText = "DateOfBirth";
dataGridView1.Columns[5].DataPropertyName = "DateOfBirth";
dataGridView1.Columns[6].Name = "Value";
dataGridView1.Columns[6].HeaderText = "Gender";
dataGridView1.Columns[6].DataPropertyName = "Value";
dataGridView1.Columns[7].Name = "RegistrationNo";
dataGridView1.Columns[7].HeaderText = "RegistrationNo";
dataGridView1.Columns[7].DataPropertyName = "RegistrationNo";
dataGridView1.Columns.Add(buttonColView);
}
sqlCon.Close();
dataGridView1.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void addButtonsToDgvBuffer(DataGridView dgv, DataGridViewButtonColumn b1, DataGridViewButtonColumn b2,
DataGridViewButtonColumn b3, DataGridViewButtonColumn b4, DataGridViewButtonColumn b5)
{
b1 = new DataGridViewButtonColumn();
b1.Text = "Edit";
b1.UseColumnTextForButtonValue = true;
b1.Width = 80;
dgv.Columns.Insert(7, b1);
b2 = new DataGridViewButtonColumn();
b2.Text = "Edit";
b2.UseColumnTextForButtonValue = true;
b2.Width = 80;
dgv.Columns.Insert(9, b2);
b3 = new DataGridViewButtonColumn();
b3.Text = "Edit";
b3.UseColumnTextForButtonValue = true;
b3.Width = 80;
dgv.Columns.Insert(11, b3);
b4 = new DataGridViewButtonColumn();
b4.Text = "Edit";
b4.UseColumnTextForButtonValue = true;
b4.Width = 80;
dgv.Columns.Insert(13, b4);
b5 = new DataGridViewButtonColumn();
b5.Text = "Edit";
b5.UseColumnTextForButtonValue = true;
b5.Width = 80;
dgv.Columns.Insert(15, b5);
}
private void loaddatautilities()
{
string connString = Konek();
MySqlConnection conn3 = null;
conn3 = new MySqlConnection(connString);
MySqlConnection conn4 = null;
conn4 = new MySqlConnection(connString);
try
{
conn3.Open();
MySqlCommand cmd = new MySqlCommand("", conn3);
cmd.CommandText = "select * from tbutility";
MySqlDataReader rdr = cmd.ExecuteReader();
int a = 0;
while (rdr.Read())
{
a++;
}
if (a > 0)
{
dataGridView1.Rows.Clear();
dataGridView1.Rows.Add(a);
dataGridView2.Rows.Clear();
dataGridView2.Rows.Add(a);
int i = 0;
conn4.Open();
MySqlCommand cmd1 = new MySqlCommand("", conn4);
cmd1.CommandText = "select * from tbutility";
MySqlDataReader rdr1 = cmd1.ExecuteReader();
dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//dataGridView1.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
while (rdr1.Read())
{
if (a > 0)
{
dataGridView1.Rows[i].Height = 50;
dataGridView1.Rows[i].Cells[0].Value = rdr1.GetString("ipserver");
dataGridView1.Rows[i].Cells[1].Value = rdr1.GetString("userid");
dataGridView1.Rows[i].Cells[2].Value = rdr1.GetString("passw");
dataGridView2.Rows[i].Height = 50;
dataGridView2.Rows[i].Cells[0].Value = rdr1.GetInt32("baudrate");
i++;
}
}
if (dataGridView1.Columns.Contains("btn") == false)
{
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
dataGridView1.Columns.Add(btn);
btn.HeaderText = "Edit";
btn.Text = "Edit";
btn.Name = "btn";
btn.UseColumnTextForButtonValue = true;
}
if (dataGridView2.Columns.Contains("btn") == false)
{
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
dataGridView2.Columns.Add(btn);
btn.HeaderText = "Edit";
btn.Text = "Edit";
btn.Name = "btn";
btn.UseColumnTextForButtonValue = true;
}
}
else
{
MessageBox.Show("Data utilities is empty");
}
}
finally
{
conn3.Close();
conn4.Close();
txtip.Clear();
txtuser.Clear();
txtpassw.Clear();
txtbaud.Clear();
}
}
private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (this.dataGridView2.Rows[e.RowIndex].Cells[0].EditedFormattedValue.ToString() == "True")
{
int st = e.RowIndex;
for (int i = 0; i < dataGridView2.RowCount - 1; i++)
{
if (i != st)
{
dataGridView2.Rows[i].Cells[0].Value = false;
}
}
}
int count = dataGridView2.Rows.Count;
for (int i = 0; i < count; i++)
{
if ((bool)dataGridView2.Rows[i].Cells[0].EditedFormattedValue == true)
{
DataTable dt11 = new ZLXIBAL().Select7(lzId);
//string xmh = dt11.Rows[0][0].ToString();
ajname = dataGridView2.Rows[i].Cells["案卷题名"].Value.ToString();
DataTable dt = new ZLXIBAL().Select8(pId, ajname);
DataTable dt1 = new DataTable();
DataTable dt2 = new ZLXIBAL().Select6(pId);
int j = 0;
int cnt3 = 0;
while (j < dt2.Rows.Count)
{
dt1.Columns.Add(dt2.Rows[j][0].ToString(), typeof(string));
cnt3++;
j++;
}
for (int ss = 0; ss < dt.Rows.Count;)
{
DataRow dr = dt1.NewRow();
for (int w = 0; w < cnt3; w++)
{
dr[dt2.Rows[w][0].ToString()] = dt.Rows[ss][0].ToString();
ss++;
}
lw++;
dt1.Rows.Add(dr);
}
dataGridView3.AllowUserToAddRows = false;
while (this.dataGridView3.Rows.Count != 0)
{
this.dataGridView3.Rows.RemoveAt(0);
}
dataGridView3.DataSource = dt1;
}
}
if (n == 0)
{
DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
btn.Name = "btnck";
btn.HeaderText = "查看";
btn.DefaultCellStyle.NullValue = "查看";
dataGridView3.Columns.Add(btn);
DataGridViewButtonColumn btn2 = new DataGridViewButtonColumn();
btn2.Name = "btnsm";
btn2.HeaderText = "扫描";
btn2.DefaultCellStyle.NullValue = "扫描";
dataGridView3.Columns.Add(btn2);
DataGridViewButtonColumn btn3 = new DataGridViewButtonColumn();
btn3.Name = "btnqk";
btn3.HeaderText = "清空";
btn3.DefaultCellStyle.NullValue = "清空";
dataGridView3.Columns.Add(btn3);
n++;
/* DataGridViewButtonColumn btn4 = new DataGridViewButtonColumn();
* btn4.Name = "btnkx";
* btn4.HeaderText = "测试";
* btn4.DefaultCellStyle.NullValue = "测试";
* dataGridView3.Columns.Add(btn4);
* n++;*/
}
}
public void refresh()
{
//JENIS KAMAR
conn.Open();
OracleDataAdapter da = new OracleDataAdapter();
DataTable dt = new DataTable();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from jenis_kamar";
da.SelectCommand = cmd;
da.Fill(dt);
dataGridViewJenis.DataSource = dt;
if (dataGridViewJenis.Columns.Count < 4)
{
DataGridViewButtonColumn newbtn = new DataGridViewButtonColumn();
newbtn.DefaultCellStyle.SelectionForeColor = Color.Green;
newbtn.DefaultCellStyle.BackColor = Color.Green;
newbtn.DefaultCellStyle.ForeColor = Color.Green;
newbtn.HeaderText = "Action";
newbtn.Name = "Button";
newbtn.Text = "Delete";
newbtn.UseColumnTextForButtonValue = true;
dataGridViewJenis.Columns.Add(newbtn);
}
OracleDataAdapter da1 = new OracleDataAdapter();
DataTable dt1 = new DataTable();
OracleCommand cmd1 = new OracleCommand();
cmd1.Connection = conn;
cmd1.CommandText = "select kode_jenis from jenis_kamar";
da1.SelectCommand = cmd1;
da1.Fill(dt1);
dataGridView2.DataSource = dt1;
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox4.Items.Clear();
for (int i = 0; i < dataGridView2.Rows.Count - 1; i++)
{
comboBox1.Items.Add(dataGridView2.Rows[i].Cells[0].Value.ToString());
comboBox2.Items.Add(dataGridView2.Rows[i].Cells[0].Value.ToString());
comboBox4.Items.Add(dataGridView2.Rows[i].Cells[0].Value.ToString());
}
//KAMAR
OracleDataAdapter da2 = new OracleDataAdapter();
DataTable dt2 = new DataTable();
OracleCommand cmd2 = new OracleCommand();
cmd2.Connection = conn;
cmd2.CommandText = "select * from kamar";
da2.SelectCommand = cmd2;
da2.Fill(dt2);
dataGridViewKamar.DataSource = dt2;
if (dataGridViewKamar.Columns.Count < 5)
{
DataGridViewButtonColumn newbtn = new DataGridViewButtonColumn();
newbtn.DefaultCellStyle.SelectionForeColor = Color.Green;
newbtn.DefaultCellStyle.BackColor = Color.Green;
newbtn.DefaultCellStyle.ForeColor = Color.Green;
newbtn.HeaderText = "Action";
newbtn.Name = "Button";
newbtn.Text = "Delete";
newbtn.UseColumnTextForButtonValue = true;
dataGridViewKamar.Columns.Add(newbtn);
}
OracleDataAdapter da3 = new OracleDataAdapter();
DataTable dt3 = new DataTable();
OracleCommand cmd3 = new OracleCommand();
cmd3.Connection = conn;
cmd3.CommandText = "select id_kamar from kamar";
da3.SelectCommand = cmd3;
da3.Fill(dt3);
dataGridView4.DataSource = dt3;
comboBox3.Items.Clear();
for (int i = 0; i < dataGridView4.Rows.Count - 1; i++)
{
comboBox3.Items.Add(dataGridView4.Rows[i].Cells[0].Value.ToString());
}
conn.Close();
}
//Subastas públicas en las que está participando el transportista.
private void LoadAuctions()
{
string token = Session.Token;
int idCarrier = Session.IdProfile;
dynamic parameters = new System.Dynamic.ExpandoObject();
//parameters.idPurchaseRequestType = 1;
parameters.idCarrier = idCarrier;
var findByIdCarrier = VirtualFairIntegration.FindByIdCarrierAndIsPublicEqualToOne(token, parameters);
List <AdminApi> lstParticipating = new List <AdminApi>();
dgvAuctions.AutoGenerateColumns = false;
if (findByIdCarrier.countRows != 0)
{
foreach (var item in findByIdCarrier.transportAuctions)
{
AdminApi users = new AdminApi();
//cambiar variables
users.id = Convert.ToInt32(item.id.ToString());
users.email = item.idPurchaseRequest.ToString();
users.dateA = item.desiredDate;
users.fullName = item.purchaseRequest.purchaseRequestStatus.name.ToString();
lstParticipating.Add(users);
}
dgvAuctions.DataSource = lstParticipating;
}
string[] arrayString = new string[] { "id", "email", "dateA", "fullName" };
foreach (var item in arrayString)
{
DataGridViewTextBoxColumn dataGrid = new DataGridViewTextBoxColumn();
dataGrid.DataPropertyName = item;
if (item == "id")
{
dataGrid.HeaderText = "ID";
}
else if (item == "email")
{
dataGrid.HeaderText = "Id Venta";
}
else if (item == "dateA")
{
dataGrid.HeaderText = "Fecha Decisión";
}
else if (item == "fullName")
{
dataGrid.HeaderText = "Estado";
}
dataGrid.Name = item;
dgvAuctions.Columns.Add(dataGrid);
}
DataGridViewButtonColumn verDetalles = new DataGridViewButtonColumn();
verDetalles.FlatStyle = FlatStyle.Popup;
verDetalles.HeaderText = "Ver Detalle";
verDetalles.Name = "Ver Detalle";
verDetalles.UseColumnTextForButtonValue = true;
verDetalles.Text = "Ver Detalle";
verDetalles.Width = 80;
if (dgvAuctions.Columns.Contains(verDetalles.Name = "Ver Detalle"))
{
}
else
{
dgvAuctions.Columns.Add(verDetalles);
}
}
private void LoadFile()
{
string fileExtension = Path.GetExtension(OpenFileDialogDataSet.FileName);
// Se limpia el archivo DATA.
DataSetDataFile = null;
// Se limpia la DataTable local.
dataSet.Columns.Clear();
dataSet.Rows.Clear();
// Se limpia el DataGridView.
DataGridViewDataSet.Columns.Clear();
DataGridViewDataSet.DataSource = null;
// Se resetea la variable Bool.
ChangesMade = false;
// Se verifica el tipo del archivo a leer.
if (fileExtension == ".csv")
{
// Leer el archivo CSV.
ReadCSVFile();
}
else
{
// Leer el archivo DATA.
ReadDATAFile();
}
// Cargar en el DataGridView el contenido del archivo leido con la BindingSource.
bindingDataSet.DataSource = dataSet;
DataGridViewDataSet.DataSource = bindingDataSet;
// Agregar al DataGridView las columnas con el número de instancia y con el botón de eliminar.
DataGridViewButtonColumn ColumnDeleteInstanceButton = new DataGridViewButtonColumn()
{
Name = "Eliminar Instancia",
Text = "Eliminar",
UseColumnTextForButtonValue = true
};
DataGridViewColumn ColumnInstance = new DataGridViewColumn()
{
HeaderText = "Instancia",
ReadOnly = true,
CellTemplate = new DataGridViewTextBoxCell()
};
DataGridViewDataSet.Columns.Insert((int)ColumnIndex.DeleteInstanceButton, ColumnDeleteInstanceButton);
DataGridViewDataSet.Columns.Insert((int)ColumnIndex.Instance, ColumnInstance);
// Colocar el numero de instancia en la columna de "Instancia" del DataGridView
FillInstanceColumn();
// Obtener y mostrar la información del conjunto de datos.
LabelDatasetNameValue.Text = Path.GetFileNameWithoutExtension(OpenFileDialogDataSet.FileName);
LabelDataSetInstanceQuantityValue.Text = dataSet.Rows.Count.ToString();
LabelDataSetAttributeQuantityValue.Text = dataSet.Columns.Count.ToString();
// Verificar el tipo del archivo.
if (DataSetDataFile != null)
{
// Archivo DATA.
// Asignar contenido único de archivos DATA.
TextBoxGeneralInformation.Text = DataSetDataFile.GeneralInformation;
LabelRelationValue.Text = DataSetDataFile.Relation;
// Encontrar valores faltantes y valores fuera del dominio para colorear las celdas.
FindMissingAndOutOfDomainValues();
}
else
{
// Archivo CSV.
// Limpiar contenido único de archivos DATA.
TextBoxGeneralInformation.Text = "N/A";
LabelRelationValue.Text = "N/A";
// Encontrar valores faltantes para colorear las celdas.
FindMissingValues();
}
}
