//
public StoreManage(string id)
{
string connectionString = $"server={"192.168.0.78"};Database={"2kdigital"};Uid={"root"};Pwd={"rladudwo"};";
//임시 db
//string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\2klab\OneDrive\2kd\Projects_c#_real\StoreManage_4\StoreManage\StoreManage\temp.mdf;Integrated Security=True;Connect Timeout=30";
InitializeComponent();
this.crud = new Crud(connectionString);
this.sqlQuery = new SqlQuery();
this.tempFuncForWinform = new TempFuncForWinform();
this.textBoxArray = new TextBox[] { textBoxStroeName, textBoxAdminName, textBoxAddressZip, textBoxAddress, textBoxBasicInformation, textBoxContractInformation, textBoxAddress2 };
this.dateTimePickerArray = new DateTimePicker[] { dateTimePickerContractDate, dateTimePickerContractDate2, dateTimePickerManagementExpense, dateTimePickerElectricityExpense, dateTimePickerWaterExpense };
this.id = id;
this.setCheckedStoreName = new SortedSet <string>();
this.menuButtonArray = new Button[] { buttonEmployeeManageTemp, buttonStoreManageTemp, buttonResultManegeTemp };
this.buttonForCreateAndUpdateArray = new Button[] { buttonSelectAddress, buttonSelectEmployee };
this.labelArray = new Label[]
{
labelCompanyName, labelCurrentDate, labelAdminName, labelStoreName, labelAdminName2, labelAddress,
labelBasicInformation, labelContractInformation, labelContractTerm, labelElectricCost, labelEmployeeCount,
labelEmployeeCount, labelManagementCostDate, labelManagementCostDateLeft, labelManagementCostDateLeft2,
labelWaterCost
};
}
public UserControl2(Employee employee, SqlQuery sqlQuery, Crud crud, TempFuncForWinform tempFuncForWinform)
{
InitializeComponent();
this.sqlQuery = sqlQuery;
this.crud = crud;
this.tempFuncForWinform = tempFuncForWinform;
this.employee = employee;
this.setCheckedResult = new SortedSet<string>();
this.listComboBox = new List<ComboBox>();
this.listTextBox = new List<TextBox>();
//라벨 배열
this.cellLabelArray = new string[]
{
"개통일", "가입자명", "은행", "모델명", "이전통신사",
"공시지원금", "리베이트/NET", "보험가입유무", "송금금액", "현금판매금액",
"모바일 개통시간", "가입자생년", "계좌번호", "일련번호", "현/카/할",
"할부원금", "요금제", "유심후납", "예정일", "카드판매금액",
"대리점", "요금제변경일", "예금주", "고객명", "출고가",
"선납금", "", "정산금", "현금", "기타차감", "매장", "",
"CIA", "개통번호", "", "", "정책추가", "유심선납", "카드",
"세후금액", "판매자", "", "비고", "약정유형", "", "MNP수수료",
"구두추가", "부가서비스추가/차감", "", "마진"
};
makeDetailTable(false, new DataGridViewCellEventArgs(0, 0));
}
public UserControl2(string id, SqlQuery sqlQuery, Crud crud, TempFuncForWinform tempFuncForWinform)
{
InitializeComponent();
this.sqlQuery = sqlQuery;
this.crud = crud;
this.tempFuncForWinform = tempFuncForWinform;
this.id = id;
}
