摘要:
declare @ids int=1 declare @count int while @ids1 begin delete from LotNO where Auto_ID=@ids end select @ids+=1 end 阅读全文
摘要:
use MarcoBarcodegoalter table [dbo].[WorkOrderRepairSheet] ADD needRepair intgoALTER TABLE [dbo].[WorkOrderRepairSheet] ADD CONSTRAINT [DF_WorkOrderRepairSheet_needRepair] DEFAULT ((1)) FOR [needRepair]GOalter table [dbo].[WorkOrderRepairSheet] alter column [needRepair] int not null 阅读全文
摘要:
private void dataGridView1_Sorted(object sender, EventArgs e) { string _sortStr = dataGridView1.SortedColumn.Name; //排序列 SortOrder _so = dataGridView1.SortOrder; //排序方向 if (_so == SortOrder.Ascending) _sortStr += " asc"; else _sortStr += " desc"; DataView _dv = dt.Defau... 阅读全文
摘要:
DataTable dtpocopy = dtPO.Copy(); DataRow[] dr = dtpocopy .Select("客户名称='" + cusName + "' and 机种代码='" + modelNo + "'", "订单数 Desc");///////////////////////////////////DataRow[] dr = dtPO.Copy().Select("客户名称='" + cusName + " 阅读全文